I am working on an SO Order generic inquiry that lists the Requested On field date as just Month Name (e.g. if date is 10/20/2025 the results should read October).
Here’s my GI edit and the resulting issue.
Answer
Display only Month Name of Date Field in GI Results
Best answer by aleksandrsechin
Use the following formula:=MonthName([SOOrder.RequestDate])
Additionally, make sure to remove the Schema Field value.
As a result:
To make it more readable, you can set a custom caption for the field — in my case, I used "My Caption", as you can see.
+11There is a table called “DateInfo” for this
If you join SOOrder to DateInfo where SOOrder.RequestDate = DateInfo.Date you can use the “Month Name” and “Month” fields to categorize by Month.
Use the following formula:=MonthName([SOOrder.RequestDate])
Additionally, make sure to remove the Schema Field value.
As a result:
To make it more readable, you can set a custom caption for the field — in my case, I used "My Caption", as you can see.
That worked! =MonthName([SOOrder.RequestDate]) thanks all :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.