Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
krithikarees
Contributor III
Contributor III

15TH OF EACH MONTH

I have a field that has all dates for each month. However I need to only pick 15th of EACH month and set it to a date ? How do I write it in the load script?

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be this

Date(MonthStart(Date) + 14) as Date

View solution in original post

1 Reply
sunny_talwar

May be this

Date(MonthStart(Date) + 14) as Date