Date Format in the Reports

Hi, I notice that in all the report (standard & customized), the date format of the printing date (on top of page) is

DD**.** MMYYYY (eg 1**.** March 2007 , 5**.** March 2007, 28**.** Feb 2007)

I dont know whether you notice there is a ‘dot’ after the date.

I wonder why and can it not to be shown by any way?

TQ

I think you will find that this is how you set it up in Regional Settings on your computer.

Go to Regional and Language options in Settings, and press CUSTOMIZE on the first tab, go to date, and change it to what you want.

In Regional and Language setting, there is no such format.

And I set it at DD/MMMM/YYYY.

This is down to how the parameters are set in the FORMAT, but, you change it per report not as a system wide thing!

/TH

The date format is set as <TODAY,0,4> as shown in the table.

May I know how to amend it in order to remove the “dot”.

TQ.

Go to the help and lookup FORMAT. Then you may need to play with it to get the right results.

I’m not going to find the exact answer for you, to do that I would need to go and play with it myself, which is something you can do, you won’t learn anything if I give you an out of the box answer [;)]

/TH

Deciced to be a little bit more helpful,

Here is a form to test the different types of formats and what they do to a date.

Copy and paste the below code into notepad. Save the file as something .txt and import. It will create a new form in object 50050.

Add a format string to the editable field and press the assitedit button. You’ll get the resulting value in the uneditable field.

When you first open the form it will set the format string to For other possible options see the help file on Format, they take them for a spin in this form.

I knocked this form up in five minutes, so don’t knock it [:P]

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.
}
}