Converting YYYYMM to YYYYMMdd but the Day can be customized.

[wonka1234]

Hi,

How can I convert YYYYMM to YYYYMMdd but the Day can be customized. .

Ie the date seems to be defaulting to the first of the month, how can i specify the day? 

Thanks.

[Luke_C]

Is there a specific date (or logic) you want to use to determine the day? Or make it fully configurable for users to choose?

[wonka1234]

@Luke_C 

I would like it configurable but also a way to make it the 13th of every month.

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

If you mean configuring the day hardcoded, you can use this formula

datetimeformat(datetimeparse([Date], '%Y%m'), '%Y-%m-13')

[Felipe_Ribeir0]

Hi @wonka1234 

The previous formula was unnecessarily complex, this one is much more clean.

datetimeparse([Date] + '13', '%Y%m%d')