Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Paris
    Posts
    1

    Thumbs up Unanswered: Date format when exporting from Paradox

    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

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas
    Posts
    182
    You need to create a calculated field and concatenate the Strval(Day(Date))&Strval(MON(Date))&Strval(Year(Da te)) into the field.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •