If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > Date format when exporting from Paradox

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-18-03, 17:51
JF Scheidegger JF Scheidegger is offline
Registered User
 
Join Date: Sep 2003
Location: Paris
Posts: 1
Thumbs up 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
Reply With Quote
  #2 (permalink)  
Old 10-03-03, 16:53
Maroonotmoron Maroonotmoron is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On