- mlpsAsked on July 22, 2014 at 08:59 AM
Is there the possibility of a math function which returns the current date and time?
This is a re-post of a comment on Form Calculation - Math Function Reference
- JotForm SupportdavidAnswered on July 22, 2014 at 10:17 AM
Yes it is, you can perform all types of calculations on date and time. Here is a demo form that you can clone to check out:
And here is a discussion about performing calculations on date and time fields:
Please let us know if you have any other questions or let us know a bit more detail about what you are trying to accomplish with this calculation and we will be happy to help.
Thank you for using Jotform!
- mlpsAnswered on July 22, 2014 at 06:12 PM
Thank you for your response, but as far as I can tell, neither the example form nor the discussion include any way to get the current date and time. Although it is possible to get a date time field to use a default value of the current date and time, I can't find a way to update this when the submission is later edited. The easiest thing would be if there were a math function which returns the current date/time (like the NOW function in MS Excel, for example).
- JotForm Support ManagerJeanetteAnswered on July 23, 2014 at 01:57 AM
Although it is possible to get a date time field to use a default value of the current date and time, I can't find a way to update this when the submission is later edited.
I just made a form with Time Picker widget and I think it might help
Please test my demo here
If this is closer, but you still have doubts, let us know and we will forward them to our devs