Try wrapping your strptime calls in coalsece like this: eval LastSeen_epoch = coalesce(strptime('LastSeen', "%m/%d/%Y %H:%M"),strptime('LastSeen', "%m/%d/%y %H:%M")) This should return the epoch time for the first format which can be successfully used to parse LastSeen. ... View more