Answered

filtered by for today's date

(0) Share

Report

Posted on by jgarciac

172

hello, please your help. I need to bring from a sharepoint list all the events that occur today, the sharepoint column has date and time format, I have dealt with UTCNOW (), but the hours and minutes of the commune and the hours and minutes of uctnow () do not They allow me to filter, how can I filter only by the date, and not include the hours and minutes? Example of column in sahrepoint: Event Date Event1 09-27-2020 16:00 Event2 09-28-2020 09:00 Event3 09-28-2020 15:00 Event4 09-29-2020 13:00 Expected result for 09-28 Event2 Event3

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Re: filtered by for today's date

Hi!

Are you using an ODATA filter? If so, did you try with the following?

YourInternalColumnName gt '@{utcNow('yyyy-MM-dd')}'

Ánimo!

Was this reply helpful? Yes No
jgarciac 172 on at

Like (0)

Report

Re: filtered by for today's date

Thank you, but that brings me the items, from today to the future, but it should only bring me those of the day

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Re: filtered by for today's date

Hola de nuevo!

Try with this instead

YourInternalColumnName gt '@{utcNow('yyyy-MM-dd')}' and YourInternalColumnName lt '@{addDays(utcNow(),1,'yyyy-MM-dd')}'

Not in my laptop, unable to test

Was this reply helpful? Yes No
jgarciac 172 on at

Like (1)

Report

Re: filtered by for today's date

excellent thank you very much...

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Re: filtered by for today's date

Issue solved, right?

Hurray! Congrats!

Thanx for your help making this community great!

Was this reply helpful? Yes No