15TH OF EACH MONTH

[krithikarees]

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?

[sunny_talwar · Accepted solution]

May be this

Date(MonthStart(Date) + 14) as Date