cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

Ignore time field on a date from SQL

Can anybody help with daylight savings time issues?

I have a collection in powerapps that lists all jobs for an employee, and of course each job includes a date.

 

Now when I pull this data from SQL into powerapps it will pull a date and a time. Before the clocks changed at the weekend it would pull 01/04/2020 00:00:00 as an example for the 1st of april. Now, since the clocks changed, it pulls in 01/04/2020 01:00:00, adding 1 hour.

 

I want to display in a gallery the jobs on a specific date. This date is defined in the app as JG_JobDate and is set when the user logs in.

 

Previously if I said, for the gallery items... Filter(AllJobs,JobDate=JG_JobDate) it worked fine, JG_JobDate does not have a time attached, just a date, but I assume it defaults to 00:00:00

 

But now, since the clocks changed, the gallery appears blank. I believe this is because 01/04/2020 01:00:00 does not equal 01/04/2020 00:00:00

 

Does anyone have any workarounds?

 

Is ther any way I can say... Filter(AllJobs,DateOnly(JobDate) = DateOnly(JG_JobDate))??

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Ignore time field on a date from SQL

Format the JobDate field as: Text(JobDate,"dd-mm-yyyy")

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Ignore time field on a date from SQL

Format the JobDate field as: Text(JobDate,"dd-mm-yyyy")

View solution in original post

Highlighted
Advocate V
Advocate V

Re: Ignore time field on a date from SQL

Good Man Yourself!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,872)