[AccessD] Date From Month Name

Steve,
 Thanks, I think yours is a bit better then mine..


CDate(Format(sMonth & "/" & 2 & "/" & Format(Date, "yyyy")))

Thanks Again!! 


WBR
Robert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Saturday, August 11, 2007 3:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date From Month Name

Robert,

Don't know if there is a more elegant way, but I think this will work...
CDate(Year(Date()) & "- " & [YourMonth] & "-" & 2)

Regards
Steve


Robert wrote:
>  
>  I'm need some help with a date function.. I'm not 100% sure of my 
> requirements but I do know that I need to find the 2nd day of the 
> month of the current year derived solely on the Month name. The month 
> name could be abbreviated or not.
> 
> 
> WBR
> Robert
> 
> 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com