+ Reply to Thread
Results 1 to 3 of 3

Thread: Date Calculations

  1. #1
    yangski
    yangski is offline
    Barn Newbie yangski is an unknown quantity at this point yangski's Avatar
    Join Date
    Jul 2009
    Posts
    26
    Rep Power
    3

    Date Calculations

    Guys,

    Does anyone know how to use date calculations? I want to know if the date stored in my database exceeds the current date... I'm using MS SQL Server 2005 right now.. Any suggestions will be appreciated. Thanks..
    yangski, July 24th, 2009 03:47 AM
    Reply With Quote Reply With Quote
  2. #2
    micky
    micky is offline
    Lazy Bum micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky's Avatar
    Join Date
    Jul 2008
    Location
    India
    Posts
    1,763
    Blog Entries
    2
    Rep Power
    8

    Do you want to do that in query?
    If yes, you can try something like
    Code:
    Datefield > now()
    Datefield is date field in database
    micky, July 24th, 2009 04:06 AM
    Get the Mantra!
    Reply With Quote Reply With Quote
  3. #3
    Wolffy
    Wolffy is offline
    Wolfmaster Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy's Avatar
    Join Date
    Mar 2008
    Location
    Peoria, IL
    Posts
    2,386
    Blog Entries
    5
    Real Name
    Wolff
    Rep Power
    15

    See Functions (T-SQL)
    Wolffy, July 24th, 2009 10:55 AM
    Wolffy
    .-- ----- ..-. ..-. -.--
     Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Similar Threads

  1. Compare user entered date to date in table
    By tuxalot in forum Microsoft Access
    Replies: 1
    Last Post: February 27th, 2009, 10:31 AM

Bookmarks

Posting Permissions

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

Forum Rules


SEO by vBSEO