cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bblackwell3
New Member

Converting Year Quarter time value to a date for comparison

Hey All. I have a SharePoint data list that uses a start date and end date, but these are apparently text. The dates use the year and the quarter, such as 2020 Q2. I need to do a comparison for validation. I want to restrict the user from entering an end date that occurs before the start date. I still want the data to write back to SharePoint as Year and Quarter

Do I need to do a conversion before comparison or is there some other way for comparison without conversion?

 

 

 

Thanks!

1 REPLY 1
RandyHayes
Super User
Super User

@bblackwell3 

You will need to include a conversion to the quarter date in your comparison formula.  There is not a way to compare quarters without it.  Either convert the initial stored value or convert the next value and compare that.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (3,281)