Answered

Query based on day difference in sharepoint

Like (0) Share

Report

Posted on 5 Jan 2024 20:20:34 by RoberthCB

Hello

I'm looking for a way to get the RegistrationDueDate (Sharepoint list) field with condition approbal and RegistrationDueDate - utcnow() le 30 days in the query for the get items to return the list but I can't find a way,

Thank you very much for the help

Annex the screen prints

Thanks a lot

All responses (3)

Answers (1)

Verified answer

Anchov 1,984 on 05 Jan 2024 at 21:00:19

Like (0)

Report
Re: Query based on day difference in sharepoint

Then your filter would need to be configured like

(Approbal eq 'Approved') and (RegistrationDueDate le '@{addDays(utcNow(),-30, 'yyyy-MM-dd')}')

Example:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt
RoberthCB on 05 Jan 2024 at 20:38:05

Like (0)

Report

Re: Query based on day difference in sharepoint

Thanks, es for past date
Anchov 1,984 on 05 Jan 2024 at 20:36:00

Like (0)

Report

Re: Query based on day difference in sharepoint

You will need to write an expression. But first a question:
Do you want the expression to calculate the date 30 days from UTC (future date) or 30 days ago (past date)?