Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAProbably not the most efficient way to do this but it works
DateTimeParse(Switch(Left([date],1),'','0','19','1','20') + Right([date],6),'%Y%m%d')