web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Answered

Expire Date

(0) ShareShare
ReportReport
Posted on by Super User 2024 Season 1

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 

Categories:
I have the same question (0)
  • eka24 Profile Picture
    20,923 on at

    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.

  • Ramole Profile Picture
    Super User 2024 Season 1 on at

    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 

  • Verified answer
    eka24 Profile Picture
    20,923 on at

    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.
  • Ramole Profile Picture
    Super User 2024 Season 1 on at

    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 

  • eka24 Profile Picture
    20,923 on at

    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.

  • Ramole Profile Picture
    Super User 2024 Season 1 on at

    HI @eka24 

     

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

     

    Thanks 

  • eka24 Profile Picture
    20,923 on at

    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.

  • Ramole Profile Picture
    Super User 2024 Season 1 on at

    Hi @eka24 

     

    Here is screenshot 

     

    idex.png

  • KrishnaV Profile Picture
    5,023 on at

    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.

  • Ramole Profile Picture
    Super User 2024 Season 1 on at

    Hi@eka24 

    Thank you 

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard