Report 1401 Date Format

We need to change the date format on our cheques to MMDDYYYY in Nav 3.70. I don’t see where I can change the format. It is currently set to Month DD YYYY.

If you export the report as txt file you can search for “CheckDateText” to gfind what you need.

CheckDateText := FORMAT(“Posting Date”,0,4);
END ELSE BEGIN
IF ChecksPrinted > 0 THEN
CurrReport.BREAK;
BalancingType := BalancingType::Vendor;
BalancingNo := Text010;
CLEAR(CheckToAddr);
FOR i := 1 TO 5 DO
CheckToAddr[i] := Text003;
ContactText := ‘’;
CLEAR(SalesPurchPerson);
CheckNoText := Text011;
CheckDateText := Text012;
END;
END;

Is that an added granule? It tells me that I do not have permission to run the file, export, test system?

To run report 1401 you need granule “Cash Manager - Check Writing”
If you already print check it’s because you already have it.

To export a object has a text file you need development granules or a solution center license.

How do I determine if I have the Development Granule. I can create reports, forms etc… isn’t that part of development?

Do you have this granules ?

7,200 Application Builder
7,300 Solution Developer

I don’t have either of those granules so that would explain why I can’t export as text. [:O]

So, does this mean that I can’t change the date format?

Yes, you can’t change report without correct granules.

Hey,

There is no need to call a different function, the FORMAT will handle it for you.

Below if a form I wrote for testing the format function on a date

I think you need the params

Try it with this test form

Any problems let us know.

/TH

OBJECT Form 50050 Date Form
{
OBJECT-PROPERTIES
{
Date=08/03/07;
Time=15:01:15;
Modified=Yes;
Version List=;
}
PROPERTIES
{
Width=11330;
Height=1870;
CaptionML=ENZ=Date Format Tester;
OnOpenForm=BEGIN
FormatString := ’ ';
ResultString := FORMAT(TODAY,0,FormatString);
CurrForm.UPDATE(FALSE);
END;

}
CONTROLS
{
{ 1101353004;TextBox;3630 ;220 ;7480 ;440 ;AssistEdit=Yes;
CaptionML=ENZ=Format String;
SourceExpr=FormatString;
OnAssistEdit=BEGIN
ResultString := FORMAT(TODAY,0,FormatString);
CurrForm.UPDATE(FALSE);
END;
}
{ 1101353005;Label ;220 ;220 ;3300 ;440 ;ParentControl=1101353004 }
{ 1101353006;TextBox;3630 ;770 ;7480 ;440 ;Editable=No;
CaptionML=ENZ=Result;
SourceExpr=ResultString }
{ 1101353007;Label ;220 ;770 ;3300 ;440 ;ParentControl=1101353006 }
{ 1101353009;Label ;220 ;1320 ;5610 ;440 ;ForeColor=16711680;
BackTransparent=Yes;
FontSize=10;
FontBold=Yes;
LeaderDots=No;
CaptionML=ENZ=Tony Hemy - DynamicsUser.Net }
}
CODE
{
VAR
FormatString@1101353000 : Text[100];
ResultString@1101353001 : Text[100];
;

BEGIN
END.
}
}

I haven’t tried it but, i guess you could delete the field on the report that show the date and create your own new date field in the format you want.

I would recommend using a field on the request form that defaults to the and use that. Then it becomes a little more generic.

:slight_smile:

/TH