Nav2013 R2 Format(date,10,'<Year4>-<Month,2>-<Day,2>') returns 0001-01-01 when date := 0D

(0) Share

Report

Posted on by Mikael Smith Larsen

150

Hi When formating a blank date, with the code shown below it returns: 0001-01-01 in Nav2013 R2. If the same code is executed in Nav2013 it returns: ''. That must be an error in Nav2013 R2, or what? Code: Var Name DataType Subtype Length Employee2 Record Employee ApplicationManagement Codeunit ApplicationManagement txtTerminationDate Text dtDate Date txtDate Text Employee2.GET('9'); txtTerminationDate := FORMAT(Employee2."Termination Date",10,'--'); MESSAGE('Employee2."Termination Date": %1\'+ 'txtTerminationDate: %2\'+ 'ApplicationManagement.ApplicationVersion: %3', Employee2."Termination Date", txtTerminationDate, ApplicationManagement.ApplicationVersion); dtDate := 0D; txtDate := FORMAT(dtDate,10,'--'); MESSAGE('dtDate: %1\'+ 'txtDate; %2\'+ 'ApplicationManagement.ApplicationVersion: %3', dtDate, txtDate, ApplicationManagement.ApplicationVersion);

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Daniele Rebussi 2,480 on at

Like (0)

Report

RE: Nav2013 R2 Format(date,10,'<Year4>-<Month,2>-<Day,2>') returns 0001-01-01 when date := 0D

Has been fixed with Cumulative Update 6: mbs2.microsoft.com/.../KBDisplay.aspx
Community Member Microsoft Employee on at

Like (0)

Report

RE: Nav2013 R2 Format(date,10,'<Year4>-<Month,2>-<Day,2>') returns 0001-01-01 when date := 0D

About two weeks ago I have translate this issue to Microsoft support. Microsoft is working to fix this problem in next hotfix in Nav2013 R2.

Best regards,