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
Happy holidays!
Spoiler
Workflow
Multi-Field Formula
DateTimeParse([_CurrentField_], "%m/%d/%Y")
Generate Rows
Initialization Expression : [Start_Date]
Condition Expression : [Date] <= [End_Date]
Loop Expression : DateTimeAdd([Date], 1, "day")
Formula
DayOfWeek = DateTimeFormat([Date], "%a")
isWeekend = [DayOfWeek] IN ("Sat", "Sun")
hours =
IF [isWeekend]
THEN 10 // weekends 10 hours
ELSE 4 // weekdays 4 hours
ENDIF
hours =
IF [DayOfWeek] = "Thu" // Thursdays off
OR [Date] IN ("2024-12-25", "2025-01-01") // holidays off
THEN 0
ELSE [hours]
ENDIF
pay = 15 * [hours]
Multi-Field Formula
DateTimeParse([_CurrentField_], "%m/%d/%Y")
Generate Rows
Initialization Expression : [Start_Date]
Condition Expression : [Date] <= [End_Date]
Loop Expression : DateTimeAdd([Date], 1, "day")
Formula
DayOfWeek = DateTimeFormat([Date], "%a")
isWeekend = [DayOfWeek] IN ("Sat", "Sun")
hours =
IF [isWeekend]
THEN 10 // weekends 10 hours
ELSE 4 // weekdays 4 hours
ENDIF
hours =
IF [DayOfWeek] = "Thu" // Thursdays off
OR [Date] IN ("2024-12-25", "2025-01-01") // holidays off
THEN 0
ELSE [hours]
ENDIF
pay = 15 * [hours]
I had trouble to find the good result because i thought that the start date was in february...
