Page 1 of 1
last date of the prior month
Posted: Fri Mar 09, 2007 12:21 am
by khaja.arshad
Hello All
Is there any function in DS sever edition to get last date of the prior month .
I have searched in forum but unable to find specfic solutuion
Thanks In Advance
Posted: Fri Mar 09, 2007 12:23 am
by rleishman
Get the day of the month (should be possible with oconv) and then subtract that number for the date.
Posted: Fri Mar 09, 2007 12:40 am
by balajisr
Get Internal value of the first day of the month using IConv
Subtract internal value by 1.
OConv the resultant internal value.
Posted: Fri Mar 09, 2007 12:50 am
by chulett
There is also the MONTH.LAST transform available in the Built-In / Dates category.
Posted: Fri Mar 09, 2007 3:19 am
by khaja.arshad
The following code given the solution
It's working
Oconv(Iconv(Arg1, "D2/") - Oconv(Iconv(Arg1, "D2/"), "DD"),"D/DMY")
Thanks to every one
Regards
Hameed
Posted: Fri Mar 09, 2007 3:38 am
by kumar_s
DATE.TAG can also be used to find the Date component.