By using this website, you agree to our Terms of Use (click here)
I've built a GI on SMEmail and the CreatedDateTime field is only showing Date in the output:
I want to see the time as well. Any ideas?
Royce - were you able to link back to the Email Activity screen from the SMEmail table?
I try, but get no fields to choose from to act as the key to open the correct email.
Chris
I can answer this myself... discovered that CreatedDateTime is in UTC and so needed to add 10 hours to that to get the actual local time. This formula gave me the required output:
=DateAdd([SMEmail.CreatedDateTime], 'h', 10 )
Would be nice to display the result in the User's local timezone but not sure how to do that in GI.
You can use the Hour() & minute () functions.
Yes agreed, it would be nice it the local time zone was taken into consideration.
Had an issue with A GI for a while where I was grabbing the exchange rate using the today() function. I would test it during the day and it would work, but later in the evening when it was passed 12am(hence it was no longer 'today') in the Acumatica time zone, my GI would fail would be empty ... Caused a lot of issues until I realized what was happening
Tim,
This worked to display the time but we want the user to be able to enter an appointment time but it only allows them to select a calendar date. Is there an additional step that can be done to accomplish this?
Hi Moira,
You want them to enter a time like 8:04am and have it filter to show all appointments for 8:04am?
Tim,
The generic inquiry is an update inquiry. The purpose is to allow the user to change the Dock appointment on multiple sales orders at one time. They enter the dock appointment on each sales order and then if the driver misses the appointment they have to reschedule. Many times our loads have ten plus sales orders so it’s very time consuming to maintain the missed appointments. The GI I created works to update the date but the time field also only allows them to enter the date not time. The field in the results shows 01/01/1900 and the original appointment time, it’s when they go into update that it doesn’t work.
I am a just a user but an IT colleague told me this about the field. The dock schedule is custom for us but I would assume there are other instances of time fields in Acumatica that would have the same problem.
The data type in the database for the DockAppointmentTime is datetime2 which does include the date even if the date portion is 0 (or 1/1/1900). The data in the SQL db looks the same and includes the 1/1/1900.
Thank you for your help.
Ah, now I see. As far as I can tell, a DateTime field only allows you to enter the Date portion. You might need a separate custom field for the Time portion.
I know this doesn't have to do with this case but if Google brings you here like me, this was my issue.
I was using a custom field but I had inadvertently used the [PXDBDate] attribute instead of [PXDBDateAndTime]
Online Members
