how to add time zone to calculation

[DRAhmed]

Case 
WHEN [@field:arrived_at_company]= 1
Then SysDateTime()
end

how to add time zone ( cairo +2)  to SysDateTime()

Edited October 23, 2022 by DRAhmed

[DRAhmed]

5 minutes ago, DRAhmed said:

Case 
WHEN [@field:arrived_at_company]= 1
Then SysDateTime()
end

how to add time zone ( cairo +2)  to SysDateTime()

i solved it 

Case 
WHEN [@field:arrived_at_company]= 1
Then DATEADD(hour, 02, SysUTCDateTime())
end

[ParkLoey]

Hi! Just wanted to drop Caspio's function reference article here as well for everyone's reference when creating calculations such as the use of DATEADD():

https://howto.caspio.com/function-reference/