Jump to content
  • 0

save the calculated date


DRAhmed
 Share

Question

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

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0
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 

Link to comment
Share on other sites

  • 0
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

 

Link to comment
Share on other sites

  • 0
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

Link to comment
Share on other sites

  • 0
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 )

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...