How to fetch UTC time in designer- process
I need to populate XdateInserted with UTC time instead of local time. Is there a way to do that?
Correction from my end.
I am storing a custom column in a table to store the date and setting the value in the property like value=$XDATEInserted:date$ it is storing in different timezone then the actual value present in XDateInserted column. Is there a way to get and store same timezone as XdateInserted column?
As I have written before, the value is always stored to be in UTC in the database but the object layer will present the value in local time, depending on the culture the executable is running with.
So, if a template is moving the DateTime value around it should be the same value in your custom column and in the XDateInserted column, you are fetching the data from.
You may need to describe your use-case in more detail. For example, where and how are you using the statement value=$XDATEInserted:date$