web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... AOT query range can we...

Finance | Project Operations, Human Resources, ...

Unanswered

AOT query range can we convert datetime field to Date for filterning

(0) Share

Report

Report

Posted on by Srimdax

338

Hi Team,

I have a field which is datetime data type and for that field sometime data is showing as 2154-12-31 23:59:59 and sometime as 2154-12-31 00:00:00. I want to use that field as data entity and use in data entity and I have given value as (validToMaxValueRange()) which is restricting records which field as 2154-12-31 23:59:59 and am missing records for 2154-12-31 00:00:00.. So now am thinking to restrict in value by converting to only date in range do we have any function for it.

If not anyother solution please?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 240,492 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

This is very closely related to Srimdax's previous thread: validto is created as 2154-12-31 23:59:59 and sometime it is created as 2154-12-31 00:00:00. I recommend addressing the other thread first, because it may (and should) solve the problem with filtering as well.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

SajeedMullaji 698

#2

Martin Dráb 327 Most Valuable Professional

#3

CU10121822-0 320

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans