Date of Last Monday 2

[mychal]

I want to create a formula, in CR 8.5, that will return the Date of last Monday. Can anybody help?

Thanks.

 

[lbass]

Try:

currentdate - dayofweek(currentdate) + 2

But if the currentdate = Monday, this would give you today's date. Is that what you want to happen?

-LB

 

[bdreed35]

I think this is closer to what you want.

currentdate - dayofweek(currentdate,crTuesday)

~Brian

 

[mychal]

I'm using bdreed35's formula, but lbass' post helped me to create bdreed35's before he posted it. Starts to both of you!