Solved

Modify GI Parameter to Display Weekdays Only

  • 29 October 2023
  • 3 replies
  • 49 views
K
Rank
Userlevel 4
Badge

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!

icon

Best answer by lauraj46 30 October 2023, 03:50

View original
Kaavya

3 replies

lauraj46
Rank
Userlevel 7
Badge +7

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

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*.
K
Rank
Userlevel 4
Badge

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! :)

 

Kaavya
lauraj46
Rank
Userlevel 7
Badge +7

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

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*.

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