Date Format Export Problem

[dennis g]

I am setting up an export process to allow users to input data through Access screens, then the data will eventually end up in a FOCUS database. However, whenever I export the date field, I get a date and time value in the resulting delimn text file. I'm using an export spec, and the date is set for YYYMMDD. Any ideas?

 

[JCarmic]

Have you thought about using a query to export the data. You could then use the DataValue() function to strip out the time

 

[dennis g]

No, I hadn't thought of that. Thanks, simple things sometimes evade my brain...

 

[dennis g]

Got the date problem worked out. This data is going into a FOCUS database and needs to be formatted a certain way. Each record needs to come down as a single line of text, no commas or quotes. Each field needs to be the entire length of its maximum set length, regardless of the value, so I guess I need trailing spaces to fill up the void?

 

[dennis g]

Wait a minute. I'm working with delimited export specs and I may have figured it out, it's just going to take a while to get the starting points and lengths coded right.