We have a GI that uses Kit Assembly Dates- we would like it to show the next weekday from current date. For example: for 10/27/2023 (Friday) it should show 10/30/2023 (Monday). How can we achieve this?
Below is how we have currently set up.
Answer
Modify GI Parameter to Display Weekdays Only
Best answer by lauraj46
Hi
Unfortunately, the full formula editor is not available for parameters. They do support some special constants such as @WeekStart and @WeekEnd, but I’m not sure how you could default to the next weekday. If the user doesn’t need to change the date on the fly, maybe you could configure the next weekday formula as a “condition” filter.
Laura
+8Hi
You could try this formula:
=DateAdd(Today(), 'd', iif(DayOfWeek(Today()) >=1 and DayOfWeek(Today())<=5, 1, iif(DayOfWeek(Today())=6, 3, 2)))
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi
+8Hi
Unfortunately, the full formula editor is not available for parameters. They do support some special constants such as @WeekStart and @WeekEnd, but I’m not sure how you could default to the next weekday. If the user doesn’t need to change the date on the fly, maybe you could configure the next weekday formula as a “condition” filter.
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.