Hi,
I am trying to create a google calendar event bud the date ov the event is dependant on the data that returns from the Formatter step.
For example if the day of the week that returns from the formatter is “sunday” than i want the event date to be thursday (the last business day in my time zone)
but if the formatter returns “wednsday” than the event date should be tuesday (the last business day in my time zone).
is that possible?
Best answer by jesse
Hey
You can use a Formatter > Date / Time > Add/Subtract Time to adjust Dates.
You may also need to use a Formatter > Utilities > Lookup Table to translate Sunday to +4d to get Thursday.
I think you may need some conditional logic also, like an “if event lands on Wednesday run this formatter step, if event lands on Sunday run a different one.” Maybe paths would also be needed in conjunction with formatter 🤔 I am curious to see what we can come up with! 🙂
Best of luck! We’re here if you have any follow-up questions!
+14Hi
Good question.
You can use a Formatter > Date / Time > Add/Subtract Time to adjust Dates.
You may also need to use a Formatter > Utilities > Lookup Table to translate Sunday to +4d to get Thursday.
Hey
+9Hey
You can use a Formatter > Date / Time > Add/Subtract Time to adjust Dates.
You may also need to use a Formatter > Utilities > Lookup Table to translate Sunday to +4d to get Thursday.
I think you may need some conditional logic also, like an “if event lands on Wednesday run this formatter step, if event lands on Sunday run a different one.” Maybe paths would also be needed in conjunction with formatter 🤔 I am curious to see what we can come up with! 🙂
Best of luck! We’re here if you have any follow-up questions!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
