
Announcements
Hi all (again!),
I seem to have had a mind blank and cannot get the following to work; can anyone help?
I have a Gallery of records formed from an SP list. I also have two Date Pickers. I would like the gallery to filter the records down to those which have been created between (and including) the two dates selected. I am trying to use the Created column in SP for this.
How is this possible? I can't seem to get it to work at all.
Many Thanks
To compare dates you should use the DateDiff function: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff
Formula will be something like this:
Filter(dataSource, DateDiff(date1, Now()) < 0 && DateDiff(Now(), date2) > 0)