[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
> 
>