How to create a view to show current events

Like (0) Share

Report

Posted on 30 Nov 2022 02:27:38 by Conway

120

I feel that this question would've been asked by thousands but I failed to find any mention of it in the internet...

Dataverse provides a whole lot of date filters like Equals, On, On or before/after, Next/Last N week/month/year...etc. But I can't find a way of using this filters to construct a view that returns just the current Event records. By 'current', I mean

Start Date is current date or before current date, and
End Date is current date or later than current date

How do other people construct the view to achieve this requirement?

I had used Start Date Last 1 year and End Date Next 1 year, but feel this isn't perfect.

Categories:

Entities

Microsoft Dataverse

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Fubar 8,076 Super User 2025 Season 2 on 30 Nov 2022 at 22:26:31

Like (0)

Report

Re: How to create a view to show current events

You have to use "Last ..." and "Next..." there is no way to do "on or before" etc based on todays actual date. Today, Tomorrow, Yesterday are standalone and can't be used in things like on or before.

For more complex situations you end up with nested AND and OR blocks in the query

Was this reply helpful? Yes No
Conway 120 on 30 Nov 2022 at 20:20:18

Like (0)

Report

Re: How to create a view to show current events

Thanks @gowrihalan04 but I am not able to enter 'current date' in the filter. When On or before is selected it expects a date value.
My impression of the above condition will fix the date to always 30 Nov 2022, which means its only valid for that day.

Was this reply helpful? Yes No
Gowri Halan 262 on 30 Nov 2022 at 13:05:19

Like (0)

Report

Re: How to create a view to show current events

@Conax Are you looking to achieve in single condition? you can add
1. Start date equal to On or Before 'current date' And End Date equals to On or After 'current date'
Try this condition.

If it satify the condition then mark the solution as accepted.

Was this reply helpful? Yes No