Date Export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a query where I am bring back the date and time with the Now().
The field length is 14 characters - YYYYMMDDHHMMSS and it comes back
perfectly when the query is generated eg. "20060202140307", but when I
export it, it comes across in the text file as: "20060202 14030", it puts a
space
between the date and time and therefore dropping off the last character.

Thanks,

Lucy.
 
I believe it is that your format is not correct. mm is for month, for
minutes you need nn Although it seems to work correctly, it may be that
somewhere in the export process it is getting confused. Try "yyyymmddhhnnss"
 
Thank you for the prompt reply Klatuu.
Sorry, I had a typing error, I do have it as "yyyymmddhhnnss",
so I still have the issue. :) Do you have any ideas?

Thanks so much.
 
Back
Top