Rudy may not know if its day or night,
I think you missed two (2) very important letters "PM".
"1/01/0001 3:00:15 PM"
I checked it in the Data Viewer and it shows "PM".
Ok, after adjusting the Language & Text Region the Data Viewer is now evaliuating properly.
but my calculated field is still playing up.
I have two Timestamp fields showing the format i want.
At the bottom is a calculated field that still shows the incorrect format.
( The calculation is just a simple START + (UNITS * 60) )
1 of 1 people found this helpful
Are you sure this file was created with the correct system formats?
Otherwise, make a clone, check your system date settings and the first time that clone is opened (as a non-hosted file), it will pick up your system settings.
Well, that put me in the right direction.
Had to create a new database and import all records from the old one.
Basically, the old database got corrupted, God knows how.
I can now change timestamp formats any way i like.
thanks to everyone...