Number of Days between two dates?

[Steve R]

Hey guys,

What I want to have is an "int" value (in # of days) that is derived from the current date and a future date, which happens to be the expiration date of a futures contract.

I can pull the Expiration Date out (Instrument.Expiry), and I can pull the current date (Using, DateTime.Now) but I personally cannot convert those to an int, double etc that I need to do some math with it.

Thanks in advance for the help.

[Steve R]

Ah the joys..

only took a few more hours to find out someone made it easy.. ToDay();

Done and working.

[Steve R]

Wait a minute guys. That only works for front month? It will not give me the numbers of days between now and expiration of a contract that is beyond the current month, so now I am back to the drawing board unless I want to try and do some convoluted figuring with the integers which is not the way to go.

So I'm back to my original problem - counting the number of day between 'now' and expiration of any contract. Sorry about jumping the gun.

Here's an example: Current date using ToDay() function is: 20130511. The Expiry date is 20130621 so the integer value subtracting one from the other is 111. Well that's correct, but clearly not what I want.

[Steve R]

Ah .DayOfYear fits the bill.

Excellent conversation with myself as I trip through this mess.

[sledge]

http://stackoverflow.com/questions/1...eft-difference

Wait a minute guys. That only works for front month? It will not give me the numbers of days between now and expiration of a contract that is beyond the current month, so now I am back to the drawing board unless I want to try and do some convoluted figuring with the integers which is not the way to go.

So I'm back to my original problem - counting the number of day between 'now' and expiration of any contract. Sorry about jumping the gun.

Here's an example: Current date using ToDay() function is: 20130511. The Expiry date is 20130621 so the integer value subtracting one from the other is 111. Well that's correct, but clearly not what I want.

[Steve R]

http://stackoverflow.com/questions/1...eft-difference

yeah i'm sure the answer is in that mess somewhere, but I gotta tell ya I'm glad I tripped over the 2 simple lines that gave me the integer with pretty much zero fuss. Thx.

[Steve R]

http://stackoverflow.com/questions/1...eft-difference

Actually bro, I took the time to slave over your link and made a much better product in the end. Just want to let you know.