last date of the prior month

khaja.arshad · Post by **khaja.arshad** » Fri Mar 09, 2007 12:21 am

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

rleishman · Post by **rleishman** » Fri Mar 09, 2007 12:23 am

Get the day of the month (should be possible with oconv) and then subtract that number for the date.

balajisr · Post by **balajisr** » Fri Mar 09, 2007 12:40 am

Get Internal value of the first day of the month using IConv
Subtract internal value by 1.
OConv the resultant internal value.

chulett · Post by **chulett** » Fri Mar 09, 2007 12:50 am

There is also the MONTH.LAST transform available in the Built-In / Dates category.

khaja.arshad · Post by **khaja.arshad** » Fri Mar 09, 2007 3:19 am

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

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 3:38 am

DATE.TAG can also be used to find the Date component.