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.
Solved
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
+9Hi
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
Translate
Hi
Translate
+9Hi
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
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.