NAV date field data with three characters month (31-Dec-14)

smmurugan

Hi Friends,

Is it possible in NAV to enter data in date field as '11-Dec-14' format?

To avoid confusion among users about date format - 'dd-mm-yy' or 'mm-dd-yy' - is it possible in NAV enter date as 11-Dec-14?

I tried both in Classic as well RTC - not accepting.

Can anyone confirm this how NAV works?

Thanks

Murugan

mohana_cse06

Date format in NAV depends on Windows Regional settings. Please change the Date Format in Regional settings of machine and try.

tinoruijs

I cannot confirm if you can't use months as text. Don't think you can.
But you could use the calender in RTC of course.
Or use day of the week plus weeknumber. Like m12 for mondag week 12.

smmurugan

Dear Mohana,

Thanks for the quick response.

Yes. That was the first thing I did. Please see the screenshot attached.

My Windows system date - 18-Dec-14

NAV Status bar date - 18-12-13

See the error below when I entered '11-Dec-14' in date field.

---

Microsoft Dynamics NAV Classic

---

'11-Dec-14' is not a valid date.

---

OK

---

smmurugan

Hi Tino,

I know these alternatives. But for the data entry users prefers to use this format to avoid any confusion.

Murugan

keoma

hi,

follow http://moxie4nav.wordpress.com/2014/12/ ... ate-value/

cheers

keoma

alternative:

you'll need following code in function MakeDateText in codeunit 1 to convert your given date (e.g. 15-MAR-11) into a valid date value:

MakeDateText(VAR DateText : Text[250]) : Integer
// additional local variables
// mPos | Integer
// monthText | Text | 10
// monthValue | Integer
// Text Constant: Text022 | JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC

Position := 1;
Length := STRLEN(DateText);
ReadCharacter(' ',DateText,Position,Length);

// begin changes
DateText := CONVERTSTR(DateText,'-',',');
monthText := SELECTSTR(2,DateText);
mPos := STRPOS(Text022,monthText);
IF mPos > 0 THEN BEGIN
monthValue := (mPos + 3) / 4;
monthText := PADSTR('',2 - STRLEN(FORMAT(monthValue)),'0') + FORMAT(monthValue);
DateText := SELECTSTR(1,DateText) + '-' + monthText + '-' + SELECTSTR(3,DateText);
END ELSE
DateText := CONVERTSTR(DateText,',','-');
// end changes

IF NOT FindText(PartOfText,DateText,Position,Length) THEN
...

cheers