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

@pgustavo

Thank you very much