Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: Access Form

  1. #1
    Regular Coder
    Join Date
    Oct 2002
    Posts
    144
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Angry Access Form

    Hi Guys,

    I am having a problem with a form. My need is to calculate the number of days from a given date to a given date and then to display the result in a number of days field.

    Help would be greatly appreciated.

    Rgards,

    The Dingbat.

  • #2
    Regular Coder
    Join Date
    Feb 2003
    Location
    California
    Posts
    925
    Thanks
    0
    Thanked 0 Times in 0 Posts
    what language?

    Jason

  • #3
    Regular Coder
    Join Date
    Jul 2002
    Location
    Kentucky
    Posts
    133
    Thanks
    0
    Thanked 1 Time in 1 Post
    Like this, using DateDiff:

    The following shows the difference in days between two dates:

    Dim intDays As Integer
    intDays = DateDiff("d", "03-31-2004", "04-02-2004")

    'Returns 2

    Hope this helps.


  •  

    Posting Permissions

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