thanks, but this is not what exactly I mean. ex: Date_One=07/07/2014 Date_Two=07/05/2014 Date_One and Date_Two are the field names. how do I subtract a days? please help! thanks! ... View more

it has no result from the field name "diff". because my formula is wrong or something missing my codes? please help. thank you. ... View more

hi, this is my formula. | eval it = strptime(Date_One, "%m/%d/%Y") | eval ot = strptime(Date_Two, "%m/%d/%Y") | eval diff = (ot - it) |table diff ex: Date_One=07/07/2014 Date_Two=07/05/2014 Can you help me how to subtract a day? Thanks! ... View more