Is there limit on no.of days PowerApps can count

[indhaa]

Hi

So I have an expiry date fields and I have set a limit to no.of days user can select. I'm able to count for one year but it is not working for more than that. If more than one year, it is prompting the validation error that I have set on the card. Just want to know if there is a limitation on this. I like to set it for 2 year. 

DataCardValue34.SelectedDate > Today()+729

FYI I have figure out a way to do this using the Date card END YEAR property if above is not possible. But it only achieve some part of what I want since it only give the years and not days (730 days). 

[rampprakash]

Hello @indhaa,

Can you please try below code 

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[indhaa]

I'm only trying to do a field validation. There is no issue selecting the date. So if more than two years it should prompt the error but now it is prompting after one year even though the selected date is valid.

If(DataCardValue34.SelectedDate > Today()+729,"Expiry date need to be less than two year") 

[indhaa]

@StalinPonnusamy any thought on this?

[StalinPonnusamy]

Hi @indhaa 

To answer your question, there is no limit for the days.

I assume you are using Edit Form. I tried the same code you described. Set the Label property of Error control to

If(DataCardValue16.SelectedDate > Today()+729,"Expiry date need to be less than two year") 

Note: This is just a warning. We need to do the same validation when submitting the form

[indhaa]

Hi 

Can you test selecting a date One year and one day or two day more. For example Dec 30 2022.  It is prompting the error msg for me even if it is not two years. That's my issue. Sorry for not clarifying.  

[StalinPonnusamy · Accepted solution]

Yes, As per my previous post screenshot, a warning message shows for 11/10/2023 but not 11/9/2023 which is less than 2 years. 

I just test it as well.

11/11/2023 - More than 2 years and shows the warning.

I assume you are using Date control and Label for this specific scenario. Are these controls within the form?

[indhaa]

My Mistake. I didn't update no.of days on my pop up msg . 

That's was the issue. Apology for the inconvenience