Date Format

[jnsimex]

Hi All,

I am trying to convert this number 20001231.00 in an Accpac date field to a date format such as 12/31/2000 in Crystal Reports.

I tried using cdate but it returns an error.

Thanks in advance.

 

[Naith]

Either download the NumberToDateUFL from the Business Objects website, or use something like:

StringVar YY := (Left(ToText(YourDate,0,""),4));
StringVar MM := (Mid(ToText(YourDate,0,""),5,2));
StringVar DD := (Right(ToText(YourDate,0,""),2));

Date(Val(YY),Val(MM),Val(DD));

Naith

 

[jnsimex]

It worked like a champ.

Thanks Naith.