Jim,
If the end result is not Excel, and you're merely opening the file to
review the data, the format may already be correct.
After you export the data, verify the output by opening the CSV file
with the R:BASE Editor or some other text editor. Do this before the
CSV file has been opened in Excel!
The yyyy/mm/dd format is likely listed. Is the file content the
desired end result, and correct?
Open the CSV file in Excel. If the date formatting is then altered to
the mm/dd/yyyy format, the date formatting is likely being applied by
Excel to match your operating system Region and Locale settings. If
you save the CSV file in Excel, the formatting will be altered to
match the Region and Locale.
Hope that provides you with some blue's clues.
Very Best R:egards,
Razzak
At 12:12 PM 6/19/2020, 'Jim Belisle' via RBASE-L wrote:
I would like to export data from RBASE to a CSV file so the one date
column is in the yyyy/mm/dd format (ISO-8601).
I have been able to successfully create a temp table with a text
column that puts my date info in this format. (I have not seen the
ability to format in RBASE the ISO-8601 format). That is why I
create a text column.
When exporting to the CSV good ole Microsoft turns data in that
column back to the normal mm/dd/yyyy DATE format instead of leaving
it a text column.
I know my end user can through a series of manipulations change the
DATA within the CSV file to what we need but I really do not want
them to have to bother with that.
Any ideas?
James Belisle
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0MhjbJ-1jRlFG0rMh-00Mtrh%40mrelay.perfora.net.
