How to populate the first day of the current year by calculation?

  • aboratgi
    Asked on December 19, 2018 at 12:44 PM

    Hi - I'm trying to insert a field that calculates the first day of the current year.

    So if today is 6/18/2020, then the field would be 1/1/2020.

    I'm trying to do this using the "Calculate field" function in conditions, but I'm getting confused. 

    I'm not sure what formula to use.

    Thanks.

  • Welvin Support Team Lead
    Replied on December 19, 2018 at 2:08 PM

    You cannot do this widget. You will have to use our regular date field then do it via conditional logic. I will create a demo form for you. I'll keep you posted. 

  • Welvin Support Team Lead
    Replied on December 19, 2018 at 2:17 PM

    Here's the demo form https://form.jotform.co/83525645362864.

    The conditional logic is like this:

    How to populate the first day of the current year by calculation? Image 1 Screenshot 20

    DateString is one of the Math Functions, guide here: https://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference

  • aboratgi
    Replied on December 19, 2018 at 2:29 PM

    Hi - but the date will not always be 6/18/2018, it will change every day. Thanks

  • aboratgi
    Replied on December 19, 2018 at 2:33 PM

    What I am ultimately trying to do is ask users "When was the date of your last rotation?". If their answer is greater than the first day of the current year, then I want to hide the second page.

    But I want it set up so that I don't want to have to change the date every year.

    Does that make sense?


    thanks.

  • Welvin Support Team Lead
    Replied on December 19, 2018 at 3:06 PM

    I see. Well, it's possible, but you will have to update the date in the condition for the next year. I tried a workaround, but it seems to be not working. Let me see if I can create another.