How to get 'date+1' and also the 'name of the day +1'?

  • ocstokrode
    Asked on March 15, 2021 at 5:52 AM

    Hi

    We want to achieve when a customer will book a meeting room on Saturday he will get the room for the weekend (Saturday and Sunday). I believe I can manage this, but I' struggling now to calculate a date +1

    I have made a test form

    1615801569 604f2ce1ca653 Schermafbeeldin Screenshot 10


    This works and I can also get the name of the date (current for test purpose only Monday is defined and working). But the formule date+1 went wrong. I get a number calculation in stead. 18694,96 ???

    The condition rule I used to calculate the +1 date is:


    1615801665 604f2d41187fa Schermafbeeldin Screenshot 21

    And I also need the "name of the day"+1
    Please can you help me and also tell what I did wrong?

    Thanks a lot!
    Marc


  • Sigit JotForm Support
    Replied on March 15, 2021 at 11:01 AM

    Greetings,

    Kindly allow me some time to conduct some tests.

    Thank you. Regards.

  • Sigit JotForm Support
    Replied on March 15, 2021 at 11:39 AM

    Greetings,

    Thank you for your patience.

    This is my cloned version of the form https://form.jotform.com/210733896140960

    If you want to duplicate the form, please follow this guide: https://www.jotform.com/help/42-how-to-clone-an-existing-form-from-a-url

    It is possible using Calculation widget and Conditional logic.

    1615821827 604f7c03da5e3  Screenshot 10

    The Calculation widget dateString function can change the date into string, then use Conditional logic to populate the other fields.

    I.e. Capturing Mon on the Booking Date (String format) and populate Booking Day Date field with Monday.

    1615822077 604f7cfd0a47b  Screenshot 21

    Repeat the process for the other days.

    1615822030 604f7cce66528  Screenshot 32

    Calculate a date + 1 and populate Booking Date + 1 field

    1615822250 604f7daae5040  Screenshot 43

    The Calculation widget dateString function can change the date into string.

    1615822446 604f7e6e1ce7c  Screenshot 54

    Related guides:

    Please give it a try, and let us know if you need further assistance.

    Regards.