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

Funaki
Funaki Member Posts: 5
edited 2022-07-14 in NAV Three Tier
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
hb6tnwufqpda.jpg
c6hghf2cg06n.jpg
oo6hkwparr8o.jpg

Answers

  • KTA8
    KTA8 Member Posts: 399
    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
    Funaki Member Posts: 5
    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
    vaprog Member Posts: 1,162
    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.

Categories