C# - Converting DateTime to Long

[EFileTahi-A]

In VB6 I could convert Date to a numeric value resulting in the total days since 1899, I need to do the same thing with c# so that I can store the dateTime in a numeric field to make possible searching an Access DataBase using the Between Keyword...

 

How can I do this?

 

int iDataNumeric = DateTimePicker1.Value. ?

[IngisKahn]

You need to use a TimeSpan object. When you subtract two DateTime objects they return a TimeSpan obejct. Then you can use TimeSpan.TotalDays.

[EFileTahi-A]

Could you post me an example?

 

thank you

[IngisKahn]

[CS]int iDataNumeric = (int)DateTimePicker1.Value.Subtract(new DateTime(1900, 1, 1)).TotalDays;[/CS]

[EFileTahi-A]

[CS]int iDataNumeric = (int)DateTimePicker1.Value.Subtract(new DateTime(1900' date=' 1, 1)).TotalDays;[/CS']

 

Thank you very much IngisKahn

[Iceplug]

There's also DTP.Value.ToOADate. That sounds like the kind of date representation that you are using (days since 12/31/1899), however it returns a Date, so you can convert it to a long/int if you need to. :)