validto is created as 2154-12-31 23:59:59 and sometime it is created as 2154-12-31 00:00:00

(0) Share

Report

Posted on by Srimdax

338

In D365Fn0, for HCMworkertitle there is field validto(EDT ValidToDateTime) which is system generated where value is created as 2154-12-31 23:59:59 and sometime it is created as 2154-12-31 00:00:00

which is checked in SSMS.

Can you please guide why it is hapenening.

I have the same question (0)

All responses (2)

Answers (0)

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

The correct highest value of the data type is 2154-12-31T23:59:59, not 2154-12-31 00:00:00. Isn't this data issue caused by a customization? If so, you'll need to fix the bug producing wrong data and then fix the data itself.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi Srimdax,

As Martin mentioned I think there is some customization related to that. Try to solve that.

I think you can hardcode the date time in query range in Ax 2012, but it's not recommended.

Refer to the below blog.

https://hellodax.wordpress.com/2015/07/10/max-value-and-min-value-utc-date-time-on-query-aot-ranges/

Thanks,

Girish S.

Was this reply helpful? Yes No