Hi all,
I have a string I'd like to convert to a date, format as follows:
YYMM
1901-->equals 2019-01
I need to have 1901 converted to Month, yyyy.
Any ideas?
Thank you.
Solved! Go to Solution.
Hi @Orion9542, if you use this formula, it should convert it into the format you are looking for. DateTimeFormat(DateTimeParse(tostring([Date]),"%y%m"), "%B, %Y")
Sorry, try this formula to get it to 2019.
DateTimeFormat(DateTimeParse("20"+tostring([Field1]),"%y%m"), "%B, %Y")
I suggest the following:
DateTimeFormat(DateTimeParse("20"+tostring([Input]),"%Y%m"),"%B, %Y")