| Author |
 Topic  |
|
|
ComZiz
Junior Member
Turkey
282 Posts |
 Posted - 23 Apr 2009 : 17:08:19
|
All my "Date Puchased" & "Date Seen" datas has been deleted with the new version 7. These values are very, VERY critical for me and I personally and manually entered all the dates for hundreds of movies. 
Please tell me how to import the date values to the new & converted database, I got backups.
Also, I see that we can no longer add "Date Seen" & "Date Purchased" columns to the "Main Grid" which is another dissapointment for me, becuase I constantly need and use those values... 
Please help, thanks.
Erke |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
ComZiz
Junior Member
Turkey
282 Posts |
Posted - 23 Apr 2009 : 20:06:32
|
Before I do that, let me share something I figured out;
I opened both databases in MSACCESS and went to the DatePurchased column to see if I can copy the column to the new database.
But the old date format is like this: 20070109
while the new format also contains the hour like: 07 12:00:00 PM
I think this is the key issue.
My question is; what would happen if I copy the old format over the new one? Would it automatically assign a default hour or would it mess it up? |
 |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
ternot
Junior Member
126 Posts |
Posted - 24 Apr 2009 : 09:56:00
|
Hi all,
the problem is related to the format of all date columns. In earlier versions these columns were just of type "text", now they are of type "date". Much better :-)
I think, the big problem with the date conversions are, as always, the different regional settings (To be found in the registry at "HKEY_CURRENT_USER\Control Panel\International\sShortDate")
Theoretically the date conversion could work like this:
- Read the regional date setting (e.g. "dd.mm.yyyy") as string
- Read the old date value (e.g. "20070109")
- Take the chars 1-4 as year, chars 5-6 as month, chars 7-8 as day (e.g. yyyy=207, mm=01, dd=09)
- Replace the placeholders in the date setting string -> 09.01.2007
- Add " 12:00:00" at the end -> 09.01.2007 12:00:00
- Write the new value into the database field
I tried this way manually with copying a date column of the old database to excel, altered the values as described before (For german date settings and in german excel the formula is like
'=TEIL(A3;7;2)&"."&TEIL(A3;5;2)&"."&TEIL(A3;1;4)&" 12:00:00"'
for english excel (also german date settings) like
'=MID(A3;7;2)&"."&MID(A3;5;2)&"."&MID(A3;1;4)&" 12:00:00"'
These values I copied into the date column of the new database, and Access accepted the values. XMM7 also ;-) So I can continue to use the fantastic new version (Thanks a lot, Alessio!)
I hope this helps
Best regards
ternot
|
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
ComZiz
Junior Member
Turkey
282 Posts |
Posted - 30 Apr 2009 : 03:49:43
|
Date problem is perfectly fixed, thank you so much.
sorry for my late reply, my computer's power suply has gone unstable lately.
Erke |
|
|
| |
Topic |
|
"Date Seen" From Old Database
