how to find first wednesday date from every month

[Anonymous]

hi all,

i need to populate a date from 1st wendenday of everymonth. means i have my dates like 'Actual Date' Column but i need to derive the date as per 'Required Output' columns. Any help. TIA

Actual Date	Required Output
30/12/2017	6/12/2017
15/12/2017	6/12/2017
3/12/2017	6/12/2017
3/1/2018	3/1/2018
1/1/2018	3/1/2018
17/1/2018	3/1/2018
1/2/2018	7/2/2018
20/2/2018	7/2/2018

[tamilarasu]

Hi Sampath,

Try,

Date:

Load [Actual Date],

WeekStart(MonthStart([Actual Date]),1,2) as [Required Output]

From

......

[petter]

You can use this expression:

  Date(MonthStart([Actual Date])+FMod(9-Weekday(MonthStart([Actual Date])),7))

[Chanty4u]

try this

Date(

MonthStart("Actual Date")

+ (2 - weekday(MonthStart("Actual Date")))

) as NewDay

[tamilarasu · Accepted solution]

Hi Petter,

I think you have to change 9 to 10. Correct me if I am wrong.

Date(MonthStart([Actual Date])+FMod(10-Weekday(MonthStart([Actual Date])),7))

[petter]

I guess your week for your country settings start on a different day of the week than mine. So it would be 9 for me and 10 for you. However I find tamilarasu‌'s solution much more elegant - I wasn't aware of the WeekStart() function in Qlik....

[tamilarasu]

Ah got it. Thanks Petter. Have a fantastic day!

[petter]

thanks - you too!

[Anonymous]

thanks to all for the help