Forum Discussion
Jiro
2 years agoFrequent Visitor
Date into Text Strings
Hi all,
I am trying to convert below values (data type: date) into text.
Example in MMddYYYY formatting:
12/30/2023
01/08/2022
07/15/2023
Convert to text strings: *keeping only year and month* so expected result should look like below
202312
202201
202307
Is there anyone who can help me with m code?
Hi, Jiro use Date.ToText(value, [Format = "yyyyMM"])