How to Find the Last day of a Month 1

[sreeramnavale]

Friends,

I have a date field (Orders.Order Date) in my datebase.

I want to print the last day of the month for that Order Date on my Crystal Report.

Please help me in putting a right formula for that.

SN

 

[lbass]

Try:

dateserial(year({Orders.Order Date}), month({Orders.Order Date})+1,01)-1

-LB

 

[ANDREWeire]

Thanks for that.. I needed a formulae to show data from a fixed start date up to the end of the previous month. Was able to fix the example given and get it sorted out...