How to get last day Of Mounth in report?

(Nitipat Sakunwongsalee) #1

i need value in report get last day of Mounth ?

(Paulo Gustavo Süffert) #2

Try the following expression:

Day(DateAdd("m",1,DateSerial(Year(Now), Month(Now),1))-1)

If you want to print this value, paste it on the DataField property with the ‘=’ sign in front.

(Nitipat Sakunwongsalee) #3


Thank you very much