How to Calculate ??

navuser1

Hi All,

Please share your knowledge..........

How to calculate Starting Date & Ending Date from
the Specified(given) Year And Month ?


Like that......

User input

Year := 2008
Month := April

Result (Output)

Startig Date := 01/04/08
Ending Date := 30/04/08

kine

You can use the virtual table "Date" to filter for period type Month, filter for all dates from the correct year and filter for the correct month and you will have start and end date.

Or you can use something like

  StartDate := DMY2DATE(1,MyMonth,MyYear);
  EndDate := CALCDATE('<+CM>',StartDate);

Edit: typing error corrected

navuser1

Thnx...Kine !!

Yes, I have used the Date Table to Solve the issue.
But Your next Tips is fine...

navuser1

kine wrote:

You can use the virtual table "Date" to filter for period type Month, filter for all dates from the correct year and filter for the correct month and you will have start and end date.

Or you can use something like

  StartDate := DMY2DATE(2,MyMonth,MyYear);
  EndDate := CALCDATE('<+CM>',StartDate);

[*]....[*]
StartDate should be....

  StartDate := DMY2DATE(1,MyMonth,MyYear);

garak

Example

message('Start = %1',format(calcdate('<-CM>',DMY2DATE(23,12,1977))));
message('END = %1',format(calcdate('<CM>',DMY2DATE(03,12,1977))));

navuser1

Great !!

kriki

[Can you change the attribute of the topic to <Solved> (or also <Good Posting>) and remove the text from the title?]
Please see Forum Rule(s) #3.9: Forum Rules.