I have two fields one is ApprovalDate - data type is datetime() and second is ApprovalSign - data type is Text (here i am concatinating Name and current date time)
#2026-7-14 14:19:02# - this is my approval date value while assigning
"End to End, Test EE2_craft-07/14/2026-19:49:02" and this is my ApprovalSign value while assigning
i can see both dates different.
may i know the reason , and how shall i send both dates same
HI Bharat,
The difference is most likely caused by time zone conversion.
In OutSystems, DateTime values are stored in UTC in the database, while a formatted text value may be displayed using the local time zone. A difference of 5 hours 30 minutes matches the offset between UTC and IST, which is why you're seeing different times.
To ensure both fields contain the same timestamp, call CurrDateTime() only once and reuse that value for both assignments. For example:
CurrentApprovalDate = CurrDateTime()ApprovalDate = CurrentApprovalDateApprovalSign = UserName + ", " + FormatDateTime(CurrentApprovalDate, "MM/dd/yyyy-HH:mm:ss")
If you're already using the same CurrDateTime() value for both fields and still seeing a difference, it would be helpful if you could share:
The expression used to assign ApprovalDate.
The expression used to build ApprovalSign.
Where you're checking the values (UI or directly in the database).
That information will help determine whether the difference is occurring during assignment, storage, or display.
Regards,
Janakiraman