Controlling the date field

je79ayps · 2007-09-27

Hello!

I've installed a Danish Navision client onto a English Windows XP. I want to change the way date is inserted in date fields in Navision. Instead of writing 11/14/81 I want to write 14/11/81.

In the "Regional and Language Options" in Windows I've (under custimization and date) changed the "short date format" from "M/d/yyyy" to "d/M/yyyy".

This seems to have "solved" my problem but is there perhaps a better way (i.e. not change the date format for whole Windows but only Navision) or is this method the "correct" (and only?) way to do it?

Jimmy

Luc_VanDyck · 2007-09-27

It is at least the easiest way.

Another way could be to rewrite a function in Codeunit 1, which deals with the input of Dates: GetSeparateDateTime.
It contains the line

IF NOT EVALUATE(Date,DateText) THEN
  EXIT(FALSE);

EVALUATE uses the Regional Settings to convert the input date to a Date-field. You'll have to replace the EVALUATE-line with your own algorithm.

je79ayps · 2007-10-04

Thanks!

Suja · 2011-02-11

HI je79ayps
I would like to know how you go about your issue in this posted topic...
I also have the same question...

I want to ensure all to use dd/mm/yy format , other than changing the system date at each PC what's the solution?

kitik · 2011-02-11

Have you read Luc Van Dyck's post? The solution is there...

Salut!

Controlling the date field

Comments

Categories