Date Syntax

[Alex097]

s_date1 = 09/05/08.
i = month(s_date1).
if i = 12 then e_date1 = date(1,1,year(s_date1) + 1) - 1.
else e_date1 = date(1,1,year(s_date1) + 1) - 1.
s_date2 = e_date1 + 1.
i = month(s_date2).
if i = 12 then e_date2 = date(1,1,year(s_date2) + 1) - 1.
else e_date2 = date(i + 1,1,year(s_date2)) - 1.

I need to know about "e_date1 = date(1,1,year(s_date1) + 1) - 1" value.
and also need to how to use syntax about date .

Tks.

Alex

 

[Scleameth]

Looks like you are trying to get a start date and end date of the next month ?
here is some code that might help - no need to validate which month you are working with:
ASSIGN
s_date1 = s_date1 - DAY(s_date1) + 32
s_date1 = s_date1 - DAY(s_date1) + 1
e_date1 = s_date1 - DAY(s_date1) + 32
e_date1 = e_date1 - DAY(e_date1).
MESSAGE s_date1 SKIP e_date1 VIEW-AS ALERT-BOX INFO BUTTONS OK.