Filter for date that are exactly 10 days from today

Like (1) Share

Report

Posted on 26 Jan 2024 15:00:04 by damiosiks

165

hi,

im trying to filter for data in a column in dataverse.

i want to send an email to users who meet my filter criteria. which means event_end_date should be exactly 10 days from today.

im currently using Fetch Xml Query but its getting me data that are within the 10 days.

<fetch> 
 <entity name="um_p012_bus_services"> 
<attribute name="um_name"/>
<attribute name="um_event_end_date"/>
 <filter type="and"> 
 <condition attribute="um_event_end_date" operator="next-x-days" value="10" /> 
 </filter> 
 </entity> 
</fetch>

is there any method that can be used? if yes, i would like suggestions. thank you

All responses (2)

Answers (1)

Verified answer

trice602 13,768 Super User 2025 Season 1 on 26 Jan 2024 at 17:26:48

Like (1)

Report

Re: Filter for date that are exactly 10 days from today

Hi @damiosiks ,

Here's a little cleaner expression; thanks to @wskinnermctc for sharing with me.

um_event_end_date eq 'addDays(utcNow(),10,'yyyy-MM-dd')'

The formatDateTime() expression is not needed because the formatting is already an option within addDays() and actually any date expression. Never stop learning!

Thanks again @wskinnermctc for the knowledge and let us know @damiosiks if the expression helps you keep going!
trice602 13,768 Super User 2025 Season 1 on 26 Jan 2024 at 15:22:28

Like (0)

Report

Re: Filter for date that are exactly 10 days from today

Hi @damiosiks ,

Please try the filter query:

um_event_end_date eq 'formatDateTime(addDays(utcNow(),10),'yyyy-MM-dd')'

Be sure to put the date expression shown above inside apostrophes. This will give you the date 2024-02-05 and will provide the filter you want.