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
Mhasan wrote: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 - 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.