Date format when exporting from Paradox [Archive]

JF Scheidegger

09-18-03, 18:51

I am currently using Paradox 8.

I have to produce a file in a text format (fixed ASCII) from a Paradox table which includes fields with dates.

Problem : the dates under Paradox have always a character between the day, the month and the year (DD.MM.YYYY for example).

In the text file, I should obtain a date without any separator (DDMMYYYY).

I tried different ways without success, and do not have much experience with the PAL Language.

Is there anybody who has experienced same problem, or better, found a solution ?

Many thanks in advance.
JFS

Maroonotmoron

10-03-03, 17:53

You need to create a calculated field and concatenate the Strval(Day(Date))&Strval(MON(Date))&Strval(Year(Date)) into the field.