Search

Close

Start Free Trial

Weekly Challenges

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

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

IDEAS WANTED

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

SUBMIT YOUR IDEA

Quick and easy one tool solution!

Cheers!

Phil

Very similar to challenge 46. Submission attached.

My solution.

Attached my solution

here is my solution for the same:

Formula + substring + datetime tool

I really do not like string > date, but it's such a good skill to learn.

Here is my solution:

This my solution.

datetimeparse(tostring(tonumber(left([date],1))+19)+right(left([date],3),2)+right([date],length([date])-3),"%Y%m%d")

datetimeparse(tostring(tonumber(left([date],1))+19)+right(left([date],3),2)+right([date],length([date])-3),"%Y%m%d")

One formula expression solution.

Sure this was a duplicate challenge.

Used a Formula tool to right an If statement replacing '0' with '19' and '1' with '20'. Then using the DateTime tool to convert the date to the correct format. The select tool was used to remove the unnecessary column generated by the process.

Used a Formula tool to right an If statement replacing '0' with '19' and '1' with '20'. Then using the DateTime tool to convert the date to the correct format. The select tool was used to remove the unnecessary column generated by the process.