Question

Display Day of Week in GI

  • 6 October 2023
  • 1 reply
  • 67 views
S
Rank
Userlevel 3
Badge

I would like to display the Day of the week in a GI,  Either display, Sunday, Monday, Tuesday, etc… 

or display, 1, 2, 3,   Where 1 is equal the first day of the week etc…

 

So for Document Date,  I would like to see 

 

Document Date   Document Day

10/6/2023          Monday

 

 

1 reply

Vignesh Ponnusamy
Rank
Userlevel 7
Badge +4

Hi @sspencer,

In the data column of the field you can use switch condition along with DayOfWeek,

=Switch(  
DayOfWeek( [SOOrder.OrderDate] )= 1, 'Sun', 
DayOfWeek( [SOOrder.OrderDate] )= 2, 'Mon',
DayOfWeek( [SOOrder.OrderDate] )= 3, 'Tue',
DayOfWeek( [SOOrder.OrderDate] )= 4, 'Wed',
DayOfWeek( [SOOrder.OrderDate] )= 5, 'Thu',
DayOfWeek( [SOOrder.OrderDate] )= 6, 'Fri',
DayOfWeek( [SOOrder.OrderDate] )= 7,'Sat')

Good Luck.!

#VP

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