Customer experience | Sales, Customer Insights,...

Entitiy view with datetime filter = older than current date time

(0) Share

Report

Posted on by Joshua-Lehmann

Hello

We have a custom datetime field "wait until" on the case entitiy. I would like to create a view which shows all cases where the "wait until" is older than the current datetime. How can I use the dynamic current datetime as a filter in a view/advanced find?

Example:
Current date time (now) 06.01.20201 10:08

Record 1:
Wait until = 05.01.2021 18:00

Record 2:
Wait until = 06.01.2021 08:00

Record 3:
Wait until = 06.01.2021 20:00

Record 4:
Wait until = 07.01.2021 09:00

Only Record 1 & 2 should be shown in the view. But when I open the same view on 08.01.2021 all 4 records should be shown.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

How tied to the time are you? Out of the box you could do a filter on the view 'On or before' = today.

Example:

Time is today at 16:00

Record 1 today at 10:00

Record 2 today at 20:00

You would see both records.

Was this reply helpful? Yes No
Joshua-Lehmann 75 on at

Like (0)

Report
Copy link

Link copied!

Hi Mike

Thanks for your suggestion, the time is quite important, since the view is used to show all cases where this date "expierd". So you know which need imediate attention.

But neverless I tried your suggestion but was not able to get it to work. Since when I choose "on or before" as filter operator I can only input a specific date but not a dynamic value like "today"?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Whoops, youre right. To correct myself. You could do something 'wild', like this:

I realize this does not solve for the time portion.

Was this reply helpful? Yes No
Vinayadav 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Mike,

You can use filter like below.

Hope this will help.

Check below

https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/220047/use-time-in-advanced-find?pifragment-97030=1

Thanks

Vinay

Was this reply helpful? Yes No
Joshua-Lehmann 75 on at

Like (0)

Report
Copy link

Link copied!

Hi Mike and Vinay

Thanks for your suggestions! However I think both of them do not solve my issue.

But I think I found a way myself which could work:

Since I think the "older than x Minutes" always is relative to the current date/time it should work to only show me recrods where the date field is < now

Was this reply helpful? Yes No
Suggested answer

CRMJetty 3,514 on at

Like (0)

Report
Copy link

Link copied!

Hello Joshua Lehmann,

Using Older than X Minutes = 1 you can achieve what you want.

Refer this image

Was this reply helpful? Yes No