Results 1 to 3 of 3

Thread: month to date? [resolved]

Threaded View

  1. Mar 24th, 2006, 07:11 AM #1
    thebloke
    thebloke is offline

    Thread Starter
    Hyperactive Member thebloke's Avatar
    Join Date
    May 2003
    Posts
    358

    Resolved month to date? [resolved]

    Guys

    I need a simple way to get a chunk of 'month to date' data from a sqlserver database?

    I'm currently using:

    MTA.DateCreated between getdate() - (day(getdate()-1) and getdate()

    MTA.DateCreated being a datetime field

    That returns everything from the first of the month but at the current time, not 00:00:00.

    Any clues?

    Peter
    Last edited by thebloke; Mar 24th, 2006 at 12:16 PM. Reason: resolved
    The Bloke
    www.blokeinthekitchen.com
    making cooking cool for blokes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width