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
Found the culprit!
My solution.
Spoiler
I attach .yxmd rather than .yxzp,
as I could not package the macro, due to the issue of Designer version...
Workflow
Formula Tool 1
[Personnel Logs] = Trim([Personnel Logs]," ")
[Date] = DateTimeParse([Date],"%m/%d/%Y")
[Time] = DateTimeParse([Time],"%I:%M %P")
Filter Tool 1
[Time] >= "20:00:00" OR
[Time] <= "06:00:00"
Filter Tool 2
[Incident] = "Murder"
Formula Tool 2
[Saboteur Name] =
Uppercase(
ReverseString(
GetWord([Result], 0) +
GetWord([Result], 1)
)
)
as I could not package the macro, due to the issue of Designer version...
Workflow
Formula Tool 1
[Personnel Logs] = Trim([Personnel Logs]," ")
[Date] = DateTimeParse([Date],"%m/%d/%Y")
[Time] = DateTimeParse([Time],"%I:%M %P")
Filter Tool 1
[Time] >= "20:00:00" OR
[Time] <= "06:00:00"
Filter Tool 2
[Incident] = "Murder"
Formula Tool 2
[Saboteur Name] =
Uppercase(
ReverseString(
GetWord([Result], 0) +
GetWord([Result], 1)
)
)
