Joined: 21 Oct 2008
Location: United States
Online Status: Offline
Posts: 41
Topic: Date and Time Math Posted: 03 Jul 2009 at 9:18am
I need to calculate the difference between two date and time fields and return a number.
I have a target date field and a target time field. I need to subtract this from the complete date field and complete time field. The result will be either a positive or negative number. How do I do this?
I thought I'd simply need to combine the date and time fields and then do simple math ... but I'm not sure how to combine the date and time fields into a single value.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum