Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

here you go

IIF(Left([date], 1)='0','19','20') + Right([date], Length([date])-1)

my solution

Awesome

One solution

Solved

Nice and quick!

datetimeparse(iif(StartsWith([date], '1'),'20'+Right([date],6),'19'+Right([date],6)),'%Y%m%d')

completed

Solved..

Challenge #46: Formatting a Date from an Integer