Date - Formula for last day of prior month?

building reports crystal reports
1

I can’t seem to find a simple formula or means to return the last day of the prior month (to today’s date) - goal is to not have to key in that date on a report that requires it.

Craig350 (BOB member since 2008-09-03)

2

I think if you do a good search, you’ll find this one very recent post.

https://bobj-board.org/t/122104/8

plessiusa :netherlands: (BOB member since 2004-03-22)

3

Ajan, thanks for the direction - solution accomplished after looking at those formulas and coming up with the following simple three to get the first date of the month and the last day of the prior month:

PriorMonth: BUT yields 11/7/2008 when run on 12/7/2008 – OK when used in conjunction with the formulas below:
Date(DateAdd(“m”,-1,currentdate))

PriorBOMDate:
Date(Year({@PriorMonth}),Month({@PriorMonth}),1)

PriorEOMDate:
Date(DateAdd(“D”,-1,DateAdd(“M”,1,{@PriorBOMDate})))

Thanks again for the help,

Craig

Craig350 (BOB member since 2008-09-03)

4

Yeah not bad for someone that has never even used Crystal. Just happened to pass by your and had posted in the other.

Happy that you solved your issue.

plessiusa :netherlands: (BOB member since 2004-03-22)