Answered

Query based on day difference in sharepoint

(0) Share

Report

Posted on 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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

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)?

Was this reply helpful? Yes No
RoberthCB on at

Like (0)

Report
Copy link

Link copied!

Thanks, es for past date

Was this reply helpful? Yes No
Verified answer

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No