Change Date Format

[nihou]

Source Format of YYYYMM

202101
202010
202009

Wanted Results Format MMYYYY

012021
102020
092020

tried below but did not work: 

DATETIMEFORMAT([Effect Date], "%m%y")

[kelsey_kincaid · Accepted solution]

Hi @nihou ,

You'll need to convert your original dates that are formatted as strings to dates before you use your formula. Additionally, you'll want to edit your formula to this:

DATETIMEFORMAT([Effect Date], "%m%Y")

[nihou]

Thank you @kelsey_kincaid !