last date of previous month

dr46014 · Post by **dr46014** » Mon Dec 18, 2006 11:21 pm

hi all
can you please tell me the code how to find lastday of previous month in dd-mm-yyyy format

chulett · Post by **chulett** » Mon Dec 18, 2006 11:40 pm

I'm not going to code it all up for you, but here are the steps you'd need to derive that:

* Get current date in any format
* Replace Day # portion with '1'
* Convert to Internal format using IConv
* Subtract 1 from Internal value
* Convert back to External format of choice using OConv

That should be simple enough to build a little routine to do.

You can also look at the MONTH.LAST transform under the Transforms / Built-In / Dates branch of the Manager for another approach.

I_Server_Whale · Post by **I_Server_Whale** » Mon Dec 18, 2006 11:43 pm

It always better to search before your post your post.

These posts will help you in achieving what you want.

viewtopic.php?t=102746&highlight=month

viewtopic.php?t=101373&highlight=month

viewtopic.php?t=100700&highlight=month

viewtopic.php?t=91657&highlight=month

Next time, a good search should atleast get you started.

Whale.

kumar_s · Post by **kumar_s** » Tue Dec 19, 2006 12:52 am

If you use database stage, you can use last_day() and add_months() function as well.