We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
Spoiler
1 %Love% reference shortcuts
2 I like that the data cleansing tool can now remove null columns
3 Annoying that DateTimeDiff had all the units built in except weeks?
2 I like that the data cleansing tool can now remove null columns
3 Annoying that DateTimeDiff had all the units built in except weeks?
I have used the floor function for the weeks instead of the expected ceiling used in the provided output. It seems to me that the numbers should reflect the whole number of time past and it should not be rounded upwards. This is the standard behaviour of the DateTimeDiff function.
Spoiler
Workflow
Workflow
I could see lot of way we can drive this challenge. I prefer the the simplest way
