Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


DateDiff help

DateDiff help

DateDiff help

I'm trying to check for any fields that are higher than a specific time in a datetime filed (i.e everything after 7:30am for that date).

I'm used to working in Crystal Reports and I just can't seem to find the proper syntax to get this to work

Any help would be appreciated

RE: DateDiff help

I assume you are creating report SQL first, if so cast your datetime field as Time

cast(datetimefield as time) you can then filter that as greater than 0700 or what ever


where cast([ReportedTime] as time) >= cast('07:00:00' as time)


RE: DateDiff help

Thank you, but I was hoping I could do it as a simple expression on the report itself, using a iif statement or datediff but the syntax is eluding me

My query itself is already pulling the first cases of the the day (MIN). I want all of the data from that query but simply want to count and highlight the date time fields (or timespan field via cast on the statement) that started after 07:30

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close