Skip to main content

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. 

@lauraj46 - Hey Laura, do you have any suggestions for this? thank you in advance!

Hi @kanupindi ,

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

Hi @lauraj46, thank you so much for your swift response. I really appreciate it! I tested with the above formula, it does work when I add a new column to the GI. But the parameter default value appears blank when I use the same formula: Please advise if I missed something. thank you again! :)

 

Hi @kanupindi ,

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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved