06-03-2014 12:00 AM
My data has date variables in the format of ddmmyyyy10. , however when I try to manually update the dataset (directly using the table view) it will only accept the format mmddyyyy. It also displays the data in mmddyyyy and I'm not sure why. This makes it extremely hard when I need to update 45000 rows via a copy and paste and only some rows copy as they should (probably not the best way to update data but I've got my reasons and its a one off).
Anyone know how I can somehow correct this and get my dates to display as they should?
06-03-2014 01:01 AM
What client are you using?
Enterprise Guide for instance is overriding data set date formats by using a format connected to the current Windows locale.
06-03-2014 01:12 AM
Depends on your Windows version.
In 8.1, go to Control Panel\Clock, Language, and Region\Language, then chose "Change date, time or number settings" on the left.
By the way, why do you need to update that amount of records manually? Can't you do it pro grammatically, by some logic or by a transaction data set?
06-03-2014 01:31 AM
Windows is already formatted to d/mm/yyyy. The variable in my dataset is formatted to ddmmyy. Screenshots below.
The below screen shots are of the variable. The first one is entered in ddmmyy format (5th December), however is displayed in mmddyy format when viewing the dataset.
The reason I'm updating them with a copy and paste is because my dataset became corrupt. I had a copy of the data in excel format and was hoping a quick copy and paste to correct the data would work. I thought it would have been quicker but going by the issues I'm having with these dates, it would have been quicker if I just created a temp dataset and overwrite the old one!!!