Last thursday date for CM from today() function

[Anonymous]

Hi experts.

I'm looking for some way to get calendar options from today() function,

Can QV get date for last thursday for current month using today()?

For example, in dimension i need to get 29.12.2016

Thanks.

[Anonymous]

Hi Stefan!

Many thanks, it works using different dates for any months:)

[tamilarasu]

Hello Андрей,

Though you got the solution, I would like to share the below one.

=Date(MonthEnd(Today()) - Pick(WeekDay(MonthEnd(Today())),4,5,6,0,1,2,3))

[johnw]

I like it. Mod() works, and I usually prefer mathematical solutions, but the pick() reads more clearly to me in this case.

[tamilarasu]

Hi John,

I am glad that you liked it.  I was not able to understand Mod() solution at the first glance. So I thought of sharing this, because this one seems to be easily understandable.