Change Date Format

Question

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 Answer

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")