TroubleShooter Posted September 12, 2019 Report Share Posted September 12, 2019 Hi, Provided the Month and Year, is it possible to get the date of the First Sunday of that Month? Quote Link to comment Share on other sites More sharing options...
0 carlJS Posted September 12, 2019 Report Share Posted September 12, 2019 Hi @TroubleShooter, You may use the syntax below on a Calculated Value to get the First Sunday of the Month. Virtual 1 represents numeric month Virtual 2 represents numeric year DATEADD ( day, (( 8 - DATEPART(weekday, CAST('[@cbParamVirtual1]/1/[@cbParamVirtual3]' as DATE) )) % 7 ), CAST('[@cbParamVirtual1]/1/[@cbParamVirtual3]' as DATE) ) Quote Link to comment Share on other sites More sharing options...
Question
TroubleShooter
Hi,
Provided the Month and Year, is it possible to get the date of the First Sunday of that Month?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.