search for: 01jan2000

Displaying 1 result from an estimated 1 matches for "01jan2000".

Did you mean: 01jan2006
2012 Jul 10
1
calculating the difference between days?
Hi List, I have one column of beginning dates and one column of ending dates, I want to find their difference. And I want to ignore the trailing zeros, basically everything after the first colon mark. Begin_date End_date 01JAN2000:00:00:00:000 02FEB2002:00:00:00:000 24MAR2012:00:00:00:000 18MAY2012:00:00:00:000 01OCT2003:00:00:00:000 02FEB2004:00:00:00:000 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 Thanks, Mike [[alternative HTML version delet...