Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Calculating on dates in fields (Word97/WinNT4)

    Could someone remind me how to layout a merge field so that I can calculate on a date that is a field in the XL data source? I need to have it say, if 'Date of Joining' is more than 1 year ago, say this, else say that.

    I'm sure I've done it before - and it's been in here, too! - but without the search facility I can't track it down!

    Thanks in advance for any help!
    Beryl M


  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Calculating on dates in fields (Word97/WinNT4)

    It involves using an IF field inside your mergefield when you do it in Word, and the date calculations inside that get even more complicated. There was a recent <post#=249902>post 249902</post#> about Word date calculations by <!profile=macropod>macropod<!/profile>, but I would suggest you consider doing the calculations in Excel, and returning the correct text string to Word. Doing things that way makes it easier to see exactly what is going on - otherwise if your field codes are not displayed, it isn't at all obvious how the values are being derived, and debugging gets to be a nightmare.
    Wendell

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Calculating on dates in fields (Word97/WinNT4)

    That sounds like a good idea, Wendell - I'll try that.

    I must admit I would like to rediscover how to calculate using dates in a field, though, just because it's bugging me that I used to be able to do it and now can't work it out again!

    Many thanks
    Beryl M


  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Calculating on dates in fields (Word97/WinNT4)

    In fact, having just checked out that post, the attachment is perfect - many thanks!
    Beryl M


Posting Permissions

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