Re: criteria for a datetime field

[forwarding to the relational database newsgroups]


"SAC" <sac@sac.com> wrote in message
news:%23vbhjtHVGHA.1868@TK2MSFTNGP09.phx.gbl...
> I'm trying to set the criteria for a datetime field for all dates not
> older
> than 60 days from the current system date.
>
> GetDate() -60 doesn't work.
>
> How do I do this?
>
> Thanks.
>
>

Look up DATEDIFF and DATEADD in Books Online.

http://msdn.microsoft.com/library/d...br />
5vxi.asp

http://msdn.microsoft.com/library/d...br />
3vtw.asp


ML

---
http://milambda.blogspot.com/

Thanks!

"ML" <ML@discussions.microsoft.com> wrote in message
news:5F2490C9-6863-4B56-9A29- DAF8DB0782E5@microso
ft.com...
> Look up DATEDIFF and DATEADD in Books Online.
>
>
http://msdn.microsoft.com/library/d..._da-db_5vxi.asp[
color=darkred]
>
>[/color]
http://msdn.microsoft.com/library/d..._da-db_3vtw.asp[
color=darkred]
>
>
> ML
>
> ---
> http://milambda.blogspot.com/[/color]

NP :)
Just remember this newsgroup.


ML

---
http://milambda.blogspot.com/