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 deleted]]

