Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Show no of days left to Christmas on a Form (2003)

    I know this is really sad - (my excuse is that I am trying and make custom form building a bit more memorable)

    But I want as part of a custom form to add a field to show how many days there are left to Christmas. Can anybody help please?

    Thanks

    Roberta

    PS does anyone know of any decent online tutorials for form building I could recommend for further study?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Show no of days left to Christmas on a Form (2003)

    Roberta, I don't use forms, and cannot help with that aspect, but if you are using VBA in your form, the

    DATEDIFF("d", Date, DateSerial(Year(Date), 12, 25))

    VBA function should get you the daycount (depending on if you want to count today or not).
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show no of days left to Christmas on a Form (2003)

    Your a genius - just had to put sets of brackets along side the "date" bit and it works a treat.

    Thanks

Posting Permissions

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