getting month from date

[sreekuax]

DISPLAY TODAY. - will give the current date.
If the date is eg : 09/01/2010 (MM/DD/YY format) How I can get the month i.e 09 from this date into a variable and display it ?

Please help

 

[davidvilla]

DISPLAY MONTH(TODAY)

There are functions to display the DAY, MONTH and YEAR
DAY(TODAY)
MONTH(TODAY)
YEAR(TODAY)

 

[davidvilla]

You can set the date format of the session using SESSIONATE-FORMAT and set it as 'mdy' or 'dmy'.
The DATE functions behave as per the session's date format.

 

[sreekuax]

Thanks David...
I was thinking and at last I tried and found a way for displaying it
here it is :

def var x as char no-undo.
assign x = string(today).
x = substring(x, 1, 2).
display x.

which will return '09' i.e month .
Any how it was great to know there are functions for this. thanks Bro.. I can use it next time

 

[davidvilla]

But, you will have to change the substring parameters with the session's date format. Instead you can use the inbuilt function.

 

[sreekuax]

here the sessions date format is mm/dd/yy and my substring works here

Bro : if you have more expertise in application area can you chk my other thread and help me ?
link : http://www.progresstalk.com/showthread.php?117564-tax-class-browser-not-working

 

[davidvilla]

sorry... i m not into applications....

 

[ttobba]

Try this little easier...

disp string(month(today), "99").

No need for assigments!

 

[GregTomkins]

Oh. My. God. This has to be the most retarded PT post ever!

 

[ttobba]

Oh. My. God. This has to be the most retarded PT post ever!

Agreed....

 

[sreekuax]

try this little easier...

Disp string(month(today), "99").

No need for assigments!

cool !!!!