Hello,
I have a problem with a formula. To explain a little, what I need to do is that, on the 4th of each month, the entry to my form is opened. and that this stays that way until the 9th of each month, which is where it closes.
For example, on the 4th the form is opened for people to enter and they can fill out their form to send. This also happens on day 5, day 6, day 7, day 8 and day 9. In other words, they have 6 days to fill out the form and send it. And then, on the 9th at 11:59 p.m., the form can no longer be entered, so they will have to wait again for the 4th of the next month to be able to enter it.
My problem is with the formula. I can't find a way for this to be done automatically, so every month I have to be aware of changing the date.
This is the formula which contains the button in its "On select" action:
If(Date(Year(Today());Month(Today());4)>Date(Year(Today());Month(Today());9);Notify("No puede ingresar al formulario ya que pasó la fecha lÃmite.";NotificationType.Error);Navigate(Form_obj;Fade))
but this occupies the logic that if 4 is not greater than 9, it takes me to the form. I have tried applying only a "Today" or a "Now", but it does not work since it will always be open in the same way.
Is there any way so that the form is only opened from the 4th to the 9th and closes on the 9th at 23:59, so that it remains closed until the 4th of the following month, and so on?
I find myself in a circle right now.
I hope can help me.
Regards
