in
All Tags » date » than (RSS)

Browse by Tags

  • Access SQL - Year greater than in query

    hi, I have a time/date column in one of my table named "comment date". Can someone tell me how I would say in a query, Where the "Comment Date" is less than 3 years old? Hopefully simple Thanks
    Posted to Access (Forum) by microsoft on 12-31-2009

  • Get Date 6 months older than today's date.

    I have a table with over a million records so it's really slow. I created a view to narrow it down but I'd like to narrow it down even more by only asking for data 6 months older than todays date. Can you add that code in the filter portion of a view? If so what would it look like? If not, iis...
    Posted to SQL Server 2005 (Forum) by microsoft on 06-30-2009

  • Move files older than "X" days based on date stamp

    I need a batch file that will move files older than 60 days or two months to a new directory. I have seen posts on moving files older the current date or older than 2 years on this forum. I'd prefer the batch to move files older than 60 days, but moving the files based on being older than 2 months...
    Posted to MS DOS (Forum) by microsoft on 06-29-2009

  • Problem: Dates less than today - 3 days.

    I have a query which converts a unix timestamp to a short date... using the format command: Format(#01/01/1970#+(([swtickets]![dateline]+7200)/3600/24),"Short Date") What I am trying to do is create a query so that it retuns everything that is less than today minus 3 days... i.e. if today is...
    Posted to Access (Forum) by microsoft on 05-29-2009
Page 1 of 1 (4 items)