How to show 1st Saturday of the next month

[sandip109]

Hi All,
I want to find out what is the 1st saturday of next month .
I have a date in a column , and I need to paas that and it should show next months 1st saturday .
Please help me .

[MFGF]

Hi All,
I want to find out what is the 1st saturday of next month .
I have a date in a column , and I need to paas that and it should show next months 1st saturday .
Please help me .

Hi,

This expression should do the trick:

_add_days(_first_of_month(_add_months([Your Date],1)), 7 -_day_of_week(_first_of_month(_add_months([Your Date],1)),7))

Cheers!

MF.

[MFGF]

It really saddens me when people sign up to Cognoise, ask a question, get an exact answer to it the very same day, then can't even take the time to say "it works" or (heaven forbid) "thank you".

Sandip109, whoever you are, your lack of any response or even acknowledgement says so much about you. Very saddening.

[Lynn]

It really saddens me when people sign up to Cognoise, ask a question, get an exact answer to it the very same day, then can't even take the time to say "it works" or (heaven forbid) "thank you".

Sandip109, whoever you are, your lack of any response or even acknowledgement says so much about you. Very saddening.

So true and not at all uncommon! Those of you reading this who take the time to post back a note of thanks, or a solution you found on your own, please know you are truly appreciated! Those of you who do offer answers are likewise much appreciated!

To those of you who sometimes let the busy-ness of life get in the way of good manners --- you will reap what you sow. Consider what you want your harvest to look like.