qman Constraint Violating Yak Guru
USA 422 Posts
sunitabeck Flowing Fount of Yak Knowledge
5152 Posts
SELECT * FROM YourTable WHERE datecolumn >= DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0) AND datecolumn <= GETDATE();
visakh16 Very Important crosS Applying yaK Herder
India 47188 Posts
quote:Originally posted by qmanBased on today's date, how can I select all records from begining of the year up to current date...?Sounds simple.....
Get records from start of calendar year to present
Posted - 09/12/2012 : 14:49:08
