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 .
Quote from: sandip109 on 22 Aug 2014 03:27:43 AM
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.
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.
Quote from: MFGF on 26 Aug 2014 10:19:23 AM
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.