Is there the possibility of a math function which returns the current d

  • Profile Image
    mlps
    Asked 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

  • Profile Image
    david
    Answered on July 22, 2014 at 10:17 AM

    Hi,

    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:

    http://www.jotform.com/40394782855365

    And here is a discussion about performing calculations on date and time fields:

    http://www.jotform.com/answers/396631-Can-I-subtract-a-fixed-date-from-a-user-entered-date-field

    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!

  • Profile Image
    mlps
    Answered on July 22, 2014 at 06:12 PM

    David,

    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).

    Kind regards,

    Andy

  • Profile Image
    Jeanette
    Answered 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