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
Best answer by Vignesh Ponnusamy
Hi
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.!
+5Hi
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.!
Hi
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.!
Hey
Do you have any ideas of how to adjust to time zone?
Would it be as simple to just add a -7 somewhere? Or would that not work in this instance because we are dealing with date instead of hours?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
