Convert Month to Date

[#1]

Hi,

My excel source I only have Month Name which is Jan, Feb, Mar and so on.  Please advise what is the script for converting to Date.  

[johnw · Accepted solution]

How do you know the year?  Is it always the current year?  How about the day?  First of the month?  Plenty of ways to do it.  Here are a couple:

makedate(year(today()),month(date#(MonthName,'MMM')),1)
date(date#(year(today()) & MonthName,'YYYYMMM'))