Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
From 30/12/1899 but what about under?
Message
From
06/10/2006 11:32:29
 
 
To
06/10/2006 11:23:41
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01159585
Message ID:
01160081
Views:
17
>How about using a date field + an integer field? The date field would have the current correct day and month and the integer would have the number of years to offset that date. I expect it would make your calculations a bit more complex, though.

So, basically, if I would have the following values presently in one date time field (the time is not indicated):

23/06/1986
03/01/1753
01/01/1400
02/02/2006
05/06/1516
06/07/1517

I would be able to use something like this spreaded in a date time field (time still not indicated) plus an integer field:

23/06/2006 20
03/01/2006 253
01/01/2006 606
02/02/2006 0
05/06/2006 490
06/07/2006 489

Is that how you saw it?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform