Recent content by Jezz

  1. J

    Changing the ownership of calendar items

    Yeah, exporting to CSV isn't an option as it will break things - I did try this - the problem is that not every field is exported or imported back. Eg. if you have a recurring event, and you've also made some exceptions to the recurrence, this will be lost. So this isn't an option unfortunately...
  2. J

    Changing the ownership of calendar items

    Hi, I'd like to know if it's possible to change the ownership of Outlook calendar items. I'm referring to the name which appears in the "From" field when you view the calendar in a table layout and add the "From" field to it. It's also the same name which you see when you open a calendar item...
  3. J

    Calculating the age of an Outlook contact doesn't work

    I agree, I think it's all good now. I couldn't find any faults with it when I tested it with different dates. And I don't have any leap babies in my contacts list so I'm not too worried about that anyhow! :) Thanks again for troubleshooting this with me!
  4. J

    Calculating the age of an Outlook contact doesn't work

    Okay I'm a bit confused again - are you now saying the formula is still not quite right and needs further work? I'm not sure what you're implying about the time. Surely the time is irrelevant, as we're only dealing with a birth date and not a birth time? If the age switches over at midnight on...
  5. J

    Calculating the age of an Outlook contact doesn't work

    BTW I just noticed your newer formula at To calculate the age of an Outlook contact - Slipstick Systems which you've modified to take account of babies under 1 year old: "To show the age of babies as 0 instead of -1, the formula compares the birthyear with the current year and enters a 0 if...
  6. J

    Calculating the age of an Outlook contact doesn't work

    Thanks again! So.... is it always perfectly correct now? Or will it still be out by a day or two on leap years? I'd prefer to use a formula that is always 100% correct on any given day - so that even when it's just one day before the person's birthday, it shows their true age. Will this formula...
  7. J

    Calculating the age of an Outlook contact doesn't work

    Awesome. I'll stick to the fixed formula then. Whenever you do convert it to the serial date, do you think you could post an update to this forum thread so I get notified?! Thanks again for helping me with this!
  8. J

    Calculating the age of an Outlook contact doesn't work

    Actually that's quite possible - I may have been mistaken about that. I'm (mostly) sure it did work when I first added the formula, several years ago. That may even have been Outlook 2003. Then again, maybe it never did work correctly and I just didn't notice it. I'm 95% sure it did work back...
  9. J

    Calculating the age of an Outlook contact doesn't work

    Not 100% sure what you're referring to, but if I go to the All Fields tab, and then select "Personal fields" from the menu there, I can see a field called Birthday which shows the date as "04 January 1989", which is correct. Is that what you mean? My regional settings (in the Windows Control...
  10. J

    Calculating the age of an Outlook contact doesn't work

    Hi Diane, I'm not using a custom form here. I've implemented the formula by opening the regular contact file (regular contact form I guess), then switching to the All Fields page, clicking the "New" button at the bottom, and adding the formula to a new field there. The field does update itself...
  11. J

    Calculating the age of an Outlook contact doesn't work

    A few years ago I added a custom field to my Outlook contacts in order to display their age based on their birthday. I used the formula from http://www.slipstick.com/outlook/contacts/calculate-the-age-of-contact/ and it worked fine. As far as I can remember, it always showed the correct age...
Back
Top