cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Expire Date

Hi

I have a Date field expire and its datePicker so i would if user entered date is less than 2 moth to flag show me kind popup and doesnt accept to enter 

 

Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Expire Date

If the users will select a future date as you suggested, then Put the formula OnChange of the DatePicker;

If(DateDiff(Today(),Start_date_picker.SelectedDate,Months)>2,
Notify("Date selected should be less than 2 months",NotificationType.Warning))

 
You can also use DAY example 60 days:
If(DateDiff(Today(),Start_date_picker.SelectedDate,Days)>60,
Notify("Date selected should be less than 2 months",NotificationType.Warning))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

10 REPLIES 10
Highlighted
Community Champion
Community Champion

Re: Expire Date

On a Button or Submit button, you can notify your users:

If(Month(DatePicker1.SelectedDate)<2,Notify(“Date selected should be less than 20months”))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Post Prodigy
Post Prodigy

Re: Expire Date

Hi @eka24 

 

Is not showing the warning when change the dates less than 2 months, i need when user select the date if the today date less than 2 month to show the warning  example if i select the datePicker 7/23/2020  and today date is 06/23/2020  it should show me the warning but not if user select 08/24/2020

 

Thanks 

Highlighted
Community Champion
Community Champion

Re: Expire Date

If the users will select a future date as you suggested, then Put the formula OnChange of the DatePicker;

If(DateDiff(Today(),Start_date_picker.SelectedDate,Months)>2,
Notify("Date selected should be less than 2 months",NotificationType.Warning))

 
You can also use DAY example 60 days:
If(DateDiff(Today(),Start_date_picker.SelectedDate,Days)>60,
Notify("Date selected should be less than 2 months",NotificationType.Warning))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Expire Date

Hi @eka24 

 

still didnt get working, when i test it, what i need is when i enter expire date example like today and ID CARD expire date is after one week all i need is to warn about the expire date is less that 60 days , and if possible a way to override the message   
Thanks 

Highlighted
Community Champion
Community Champion

Re: Expire Date

What is ID CARD?

Is it a textbox or a column in your database?

can you give a screen shot

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Post Prodigy
Post Prodigy

Re: Expire Date

HI @eka24 

 

Its in my sharepoint list and date field, i also do have another today date field in the database

 

Thanks 

Highlighted
Community Champion
Community Champion

Re: Expire Date

Please add the screenshot.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Post Prodigy
Post Prodigy

Re: Expire Date

Hi @eka24 

 

Here is screenshot 

 

idex.png

Highlighted
Community Champion
Community Champion

Re: Expire Date

Hi @Ramole ,

 

Please try this:

If(DateAdd(Today(),-2,Months) >= DatePicker3.SelectedDate,Notify("The selected Date is 2 months older",NotificationType.Error,800))

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,646)