When I select date from calendar why year always wrong? (Dynamic NAV 2018)

Funaki

Hi Expert

Please see in attachments why year always wrong ??

Actually when I type be manual if I input year 4 digits such as 01/01/2022 error still occur but if I input 2 digit it's can work by properly.

May be I think error is came from SQL. please give me some suggestion How to fixed its?

Best Regards,

Funaki

KTA8

If you type also the time, does it also raise error? You could check the other date time that you've on your left

Funaki

KTA8 wrote: »

If you type also the time, does it also raise error? You could check the other date time that you've on your left

Thank you for your replies, but error occur in every Date Fields in system so maybe I think root cause is my SQL collation.

vaprog

Check Windows date / Time localization settings.

I don't know which ones are relevant here, so check them on the client, NST server and SQL server for any involved users.
Also reset (or re-set, if you must) any date related options in the NST configuration.