Skip to main content
Solved

Trying to see the time a Sales Order was created


claudematherne24
Jr Varsity III
Forum|alt.badge.img

I’m trying to pull in the date and time a Sales Order was created for some metrics for my shipping department.  They have a cutoff time, where and order entered before the cut off time should be shipped same day. 

 

When I look at the SOOrder table, it looks like I should be able to use SOORder.CreatedDateTime, but in the GI, I only see the date, not the time.  Is there a way to make the time exposed.  And maybe even better, a way to split the date and time?

Best answer by aaghaei

If you want the date & time in two fields, you already have the date portion so just add a new column, caption it “Hour” and use this “=[SOOrder.CreatedDateTime_Hour]” so it will give you the Hour in a separate column.

View original
Did this topic help you find an answer to your question?

9 replies

aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • August 12, 2024

In your GI “Result Grid” when you are selecting your “Data Field” instead of selecting “CreatedDateTime” either enter or select the full schema (i.e. =[DAC.Field]) from schema like “=[SOOrder.CreatedDateTime]” and you will get the full value including time. Use the Caption Column to give your field a proper name otherwise you will see something like “SOOrder_Formula….”

Caption column by default is hidden. Use the “Column Configuration” tiny button to add it to your grid.


Graeme Laughton-Mutu
Freshman II
Forum|alt.badge.img

On a Generic Inquiry, if you enter the full table/field name as a formula, it will show the raw data without applying the display rules of that field.

On the Results Grid, use:

=[SOOrder.CreatedDateTime]

 

Note: DateTime fields are stored in the server time, and converted when displayed to the local time of the site/user preferences.
You may need to work with the formula to convert it if your server time is different to your local time.

In the example below, the raw server time is UTC, and the local time is UTC+12 

 

 

 


claudematherne24
Jr Varsity III
Forum|alt.badge.img

Are there any good ways to split that data?  Getting date separated from time?


Graeme Laughton-Mutu
Freshman II
Forum|alt.badge.img
claudematherne24 wrote:

Are there any good ways to split that data?  Getting date separated from time?

There are a range of Date/Time functions in the formula builder you could use to extract the parts of the DateTime you need and string together with separators.

 

 


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • Answer
  • August 12, 2024

If you want the date & time in two fields, you already have the date portion so just add a new column, caption it “Hour” and use this “=[SOOrder.CreatedDateTime_Hour]” so it will give you the Hour in a separate column.


claudematherne24
Jr Varsity III
Forum|alt.badge.img

SOORder.CreatedDateTime_Hour gives me a weird result.  CreatedDateTime gives me 9:25 pm, CreatedDateTime_Hour returns 15.


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • August 12, 2024

It is not weird. Depending on your UTC +/- you might need to +/- a fixed hour to get the result depending on your time zone. All the information you need is either provided by @Graeme Laughton-Mutu or me. you just need to decide what approach best suits you and proceed accordingly.


claudematherne24
Jr Varsity III
Forum|alt.badge.img

The hour difference seemed weird to me.  15 would not be 9pm standard time.  Either way, I added the time difference like you suggested and got the results I am looking for.  Thank you.


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1176 replies
  • August 13, 2024

No worries. Happy to see you got what you needed.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings