in reply to how to compare time between 2 fields ?
Conversion among datetime formats is fraught with many complications; adopt one of Perl's desiderata: laziness.