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:23:41
 
 
To
06/10/2006 11:11:16
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01159585
Message ID:
01160076
Views:
19
>>Depending on how you use those dates, you can store them either as numbers or as strings.
>
>I have calculations on those dates, so is the ability of storing them as numbers would still be applicable? If yes, how one would proceed to store a date under a numeric approach?

Michel,

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.

Regards,
Jim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform