svl_kent Posted January 2, 2010 Share Posted January 2, 2010 Hello!I have the follwing code in a SELECT:WHERE MONTH(new_date) = (MONTH(GETDATE())-1)It works very well - except now in jan - beacuse MONTH - 1 equals 0 - not 12....Anyone who could get me a beter solution?TIA / Kent Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.