We were trying to do calculations on orders created each day but the date/time field constrains us. Parsing out the month/day/year into a new field should have worked, however we are noticing some unusual discrepancies. It appears anything after 7pm EST is rolling to the next day unprompted.
@adaughenbaugh95 What you’re seeing is that all dates are actually stored in the database in UTC time, when calling a field into a GI it will adjust for user time zone.
Exceptions are when the field is used in an expression it will force the UTC value.
Users are getting an error trying to filter on the field.
Filter on columfield = @Today (today) or @Today - 1 (yesterday)
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
I had to reformat my field further. =cdate(Concat(CStr(Month(dateadd([SOOrder.CreatedDateTime],'h',-5))),'/',CStr(Day(dateadd([SOOrder.CreatedDateTime],'h',-5))),'/',CStr(Year(dateadd([SOOrder.CreatedDateTime],'h',-5)))))
@adaughenbaugh95 What you’re seeing is that all dates are actually stored in the database in UTC time, when calling a field into a GI it will adjust for user time zone.
Exceptions are when the field is used in an expression it will force the UTC value.
@adaughenbaugh95 What you’re seeing is that all dates are actually stored in the database in UTC time, when calling a field into a GI it will adjust for user time zone.
Exceptions are when the field is used in an expression it will force the UTC value.
@adaughenbaugh95 What you’re seeing is that all dates are actually stored in the database in UTC time, when calling a field into a GI it will adjust for user time zone.
Exceptions are when the field is used in an expression it will force the UTC value.
Users are getting an error trying to filter on the field.
Filter on columfield = @Today (today) or @Today - 1 (yesterday)
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
I had to reformat my field further. =cdate(Concat(CStr(Month(dateadd([SOOrder.CreatedDateTime],'h',-5))),'/',CStr(Day(dateadd([SOOrder.CreatedDateTime],'h',-5))),'/',CStr(Year(dateadd([SOOrder.CreatedDateTime],'h',-5)))))
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
