Form Calculation: Is there a way to format the calculation field as date?

  • ZTEXConstruction
    Asked on April 26, 2024 at 3:42 PM

    I have a form that starts with one date, and the staff needs to fill their working hours per day. When using the Form Calculation field, I used the Date Field + 1, but a.- it only shows numbers and b.- when exporting and formatting it as Date, the year is 1900 and not the current date year.

    Jotform Thread 14313371 Screenshot
  • Aravir JotForm Support
    Replied on April 26, 2024 at 5:00 PM

    Hi ZTEXConstruction,

    Thanks for reaching out to Jotform Support. You can add a dateString function in your formula to show the date in the Form Calculation widget. Here's how to do that:

    1. In Form Builder, select the Form Calculation field and click the Wand icon.
    2. Click the Function icon and search for dateString.
    3. Then enclose your existing formula with close parenthesis and click on Save.

    Form Calculation: Is there a way to format the calculation field as date? Image 1 Screenshot 30

    Checkout the screencast below to see the result:

    Form Calculation: Is there a way to format the calculation field as date? Image 2 Screenshot 41

    That's it. Let us know if you have any other questions.

 
Your Answer