Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Days between calculation (2003)

    I have two Form Fields to enter dates - a starting and ending date. I've left the default bookmarks Text1 and Text2. I've then inserted a 'formula' field and set it to '=Text2-Text1'. Having entered two dates and updated the formula field it displays zero!? The Text2 date occurs after the Text1 date, and I've tried formatting the field using 0 or ###0, but the result is still zero. How can I correct this? Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Days between calculation (2003)

    Dates in Word are just text, they aren't stored as numbers (as in Excel). So you cannot simply subtract two dates. See Macropod's <!post=Date Calculations in Word (2.46),249902>Date Calculations in Word (2.46)<!/post>.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •