Razzak, Thanks for the blue's clue. I did not think of looking at the file from within RBASE first. Nor did I think about how the end user would be opening the file. They may not use Excel.
We are sending it to a vendor that uses the info for state tax purposes. I will check this out. Jim From: [email protected] On Behalf Of A. Razzak Memon Sent: Monday, June 22, 2020 10:29 PM To: [email protected] Subject: Re: [RBASE-L] - ISO-8601 date format 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0MhjbJ-1jRlFG0rMh-00Mtrh%40mrelay.perfora.net. ________________________________ -- 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/CY4PR0201MB3394722F2851AE09A7EC372AA0940%40CY4PR0201MB3394.namprd02.prod.outlook.com.
