Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
How to get the last date of the month in the expression Max({<Year={$(=Max(Year))},Month={$(=Month(Max(TranDate)))}>} TranDate)
where TranDate is in DD/MM/YYYY format and I need the last date of the month also in the same format.
Monthend returns a timestamp, not a date.
May be this:
Date(Max({<Year={$(=Max(Year))},Month={$(=Month(Max(TranDate)))}>} TranDate), 'DD/MM/YYYY')
Date(MonthStart(max(TranDate),1)-1,'DD/MM/YYYY')
Although I wonder if this is working also:
Date(Max({<TransDate>}TransDate), 'DD/MM/YYYY')
add date to ur exp?
chk dis
Gysbert is there a reason you are first calculating the next month's start and then subtracting 1 to get month end? Is there a reason not to use Date(MonthEnd(Max(TranDate)),'DD/MM/YYYY')
Monthend returns a timestamp, not a date.
Hi,
Try like this
Date(Max({<Year={'$(=Max(Year))'},Month={'$(=Month(Max(TranDate)))'}, TranDate=>} TranDate), 'DD/MM/YYYY')
Hope this helpsyou.
Regards,
jagan.
Isn't that true for MonthStart as well? I though it returned a TimeStamp as well. I might be totally wrong and it would be a good to know kind of thing