Challenge #46: Formatting a Date from an Integer

[Shaktikdhar]

[Neeraj1584]

Challenge #46

[Sanz_shetty_115]

Please find the attached output

[Maxine]

My solution to Challenge 46

[OlonJohnson]

File attached

1. Using formula to replace "1" and "0 with "20" and "19":

IF Substring([date],0,1)=='1'
THEN ('20' + Substring([date],1,9))
ELSE ('19' + Substring([date],1,9))
ENDIF

2. Changing string to readable date format, then changing column to date type using Select tool:

DateTimeParse([date_new],"%y%m%d")

3. Validation using formula and filtering for mismatches (column=1) in joined table on legacy table date columns:

IF [DateTime_Out]!=[date_new]
THEN '1' ELSE 0
ENDIF

[VMSALDANA]

solution proposal attached

[Raj]

solved!

[LuisLeon]

Solution!

[AnkitaDutta22]

done

[thkjoseph]

done