Oh, I'm sorry sir. I thought you wanted to actually learn where to find this basic stuff instead of being spoonfed by this board.<BR><BR>And how well did you study that link? When I go there and click the Functions keywords I get to this page:<BR><BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtorimethods.asp<BR><BR>and voila! It's there. <BR><BR>Hint: for extracting the month you use the MONTH() function....<BR><BR>And from the nearly 4000 posts I made I sent very few people up the garden path. At least you don't have to worry I'll be sending you the wrong path again.