Answered

Is it possible to schedule dates automatically?

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone,

First of all, I appreciate all the help you have given me so far. I would like to know if there is a way to program openings of a part of the application so that I don't have to spend every month editing it.

At the moment, I have restricted the use of access to a part of my App so that it can only be accessed on established dates. To do this, I used the following function:

If(
 Date(
 2022;
 04;
 09
 ) < Today();
 Notify(
 "No puede ingresar al formulario ya que pasó la fecha límite.";
 NotificationType.Error
 );
 Navigate(
 Form_Inf_Tras;
 Fade
 )
)

I would like to know if there is a way for this action to be applied on the 4th of each month and be closed on the 9th of each month, so that I don't have to constantly modify the function each month.

Regards,

Emilio M.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

zmorek 3,272 on at

Like (1)

Report

Forgive the formatting, but using Date(Year(Today()),Month(Today()),4) should produce a date value that's of current year and month, and day 4. Then you'd used Date(Year(Today()),Month(Today()), 9) for the other portion.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Thanks you @zmorek,

If( Date( Year(Today()); Month(Today()); 9 ) < Date( Year(Today()); Month(Today()); 4 ); Notify( "No tienes ingreso al formulario. Pasó la fecha límite"; NotificationType.Error ); Navigate( PORTADA_INCENTIVOS; Fade ) )

I have left the function as follows and it works perfectly as you indicated.

Regards,

Emilio M.

Was this reply helpful? Yes No
zmorek 3,272 on at

Like (0)

Report

Thank you! If that solved your questions, please press the "Accept as Solution" button so that others may benefit from the answer as well.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @zmorek
I have tested the solution during this time but it does not work for me at all. My problem is that I need all the dates between those two established dates to be considered.

For example, I want my form login to open on the 4th of every month and close on the 9th of each month, throwing a "you can't log in as the deadline has passed" message. In this case, I need to consider the days after the 4th, by which I mean the 5th, 6th, 7th and 8th of each month.

For Example:
I tried using other dates. For example, since it is defined that the 4th of each month < the 9th of each month, it is taking the logic that it will always be correct. therefore, if I find myself on the 10th of the month, the form will continue to let me in and if I find myself on the 1st of the following month, too.

but I only need that you can enter from the 4th of each month only until the 9th of each month.

Is there any way to do this?

Was this reply helpful? Yes No
zmorek 3,272 on at

Like (1)

Report
And( Today() > Date( Year(Today()), Month(Today()), 3 ), Today() < Date( Year(Today()), Month(Today()), 10 ) )

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi @zmorek ,
Thanks you, I had tried to add a && but inside the if... I think that's why it didn't work. Now it's working fine thanks to you. One last question, where could I add an error message if the deadline has passed? (for example if we are at 22 and the closing date was 21, so that it does not allow you to enter and you get a notification type).

I used this formula:
If( And( Today() > Date( Year(Today()); Month(Today()); 21 ); Today() < Date( Year(Today()); Month(Today()); 23 ) ); Navigate( Form_Inf_Tras; Fade ); Notify( "Ha pasado la fecha límite."; NotificationType.Error ) )
This is ok?

I really appreciate your help and sorry for not understanding at first, I'm kind of new to this.

Was this reply helpful? Yes No