SQL Server Date Syntax

[pthalacker]

Can someone give me some direction on simulating the VFP GoMonth function in Sql Server? I need to be able to establish dates like the end of this month, end of last month, end of this quarter, first quarter, beginning of last quarter. Any help appreciated

pamela

 

[bborissov]

Take a look in DateAdd() function in BOL.
Also check faq183-5842 for dateTime Tips and tricks.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP