How to Calculate ??

navuser1 · 2008-10-01

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 · 2008-10-01

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 · 2008-10-01

Thnx...Kine !!

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

navuser1 · 2008-10-01

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 · 2008-10-01

Example

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

navuser1 · 2008-10-01

Great !!

kriki · 2008-10-03

[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.

How to Calculate ??

Comments

Categories