save the calculated date

[DRAhmed]

i have a formula like this 

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

the problem is it keeps showing me the current data and time 

this formula is linked to a checkbox 

i want it to save the date it first get when the checkbox is checked not the current date and time

[DRAhmed]

On 10/30/2022 at 6:43 PM, DRAhmed said:

@GoodBoy 

with my current formula , it shows the data and time when this checkbox is checked in the table

but in the report datapage it generates a  new date and time ( current date and time )

i have found a way around 

i made a virtual field with autovalue 

paramater showing directly from the table 

[GoodBoy]

Hello. Please confirm your expected results? What date value should display or save? Please note that 'SysUTCDateTime()'  is the syntax for timestamp which is why it displays the current date and time.

[DRAhmed]

1 minute ago, GoodBoy said:

Hello. Please confirm your expected results? What date value should display or save? Please note that 'SysUTCDateTime()'  is the syntax for timestamp which is why it displays the current date and time.

i want the date and time of time zone cairo,egypt to be saved

 

[GoodBoy]

You can try the 'SysDateTime()' syntax so it will obtain your device's current date and time automatically.

CASE 
WHEN [@field:approved]= 1
THEN SysDateTime()
END

 

[DRAhmed]

1 minute ago, GoodBoy said:

You can try the 'SysDateTime()' syntax so it will obtain your device's current date and time automatically.

CASE 
WHEN [@field:approved]= 1
THEN SysDateTime()
END

 

1) this will show : 

10/30/2022 08:36:16

and i dont know what time zone this is because its not my time zone 

i think the server time zone 

 

2) will its be saved or everytime i open it will give the current time only

[DRAhmed]

16 hours ago, DRAhmed said:

i have a formula like this 

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

the problem is it keeps showing me the current data and time 

this formula is linked to a checkbox 

i want it to save the date it first get when the checkbox is checked not the current date and time

@GoodBoy 

with my current formula , it shows the data and time when this checkbox is checked in the table

but in the report datapage it generates a  new date and time ( current date and time )

[IamNatoyThatLovesYou]

Hello @DRAhmed, you may try having custom localization and set it to your time zone and use it in the datapage.