Late date of Month..

[Mhasan]

Can anybody tell me How to Get the Last date of the month....
Ex : input 1 feb 1993
I need output As 28 feb 1993 How to achive this.

[ArndW]

Try

Code: Select all

DateFromDaysSince( -1 ,StringToDate('1993/02/01','%yyyy/%mm/%dd')) 

[Mhasan]

Thanks For info ...
My requiremnt is i need last date of the month from the given input date ..not the previous date... -1 will only give me previous Date

[baglasumit21]

Thanks For info ...
My requiremnt is i need last date of the month from the given input date ..not the previous date... -1 will only give me previous Date

Try using
ConvertMonth((Oconv('1993/02/01'), 'D-YM')), "L")

[Mhasan]

Thanks
That will work out in Basic transformer
How to do the same in usiing Parallel Transformer.

[ArndW]

Mhasan - I didn't give you the complete answer on purpose. The DateFromDaysSince() function using -1 will give you date one day prior to the input. So all you need to do is change your date to the first day of the next month (perhaps using string-based functions?) and then apply DateFromDaysSince(). If this is too much work, try using the forum's search functionality and you will discover that this is not the first time the question has been asked and answered.