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

  • Profile Image
    ocstokrode
    Asked on March 15, 2021 at 05: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


    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

    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


  • Profile Image
    Sigit_W
    Answered on March 15, 2021 at 11:01 AM

    Greetings,

    Kindly allow me some time to conduct some tests.

    Thank you. Regards.

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

    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_

    Repeat the process for the other days.

    1615822030_604f7cce66528_

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

    1615822250_604f7daae5040_

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

    1615822446_604f7e6e1ce7c_

    Related guides:

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

    Regards.