Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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'))
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'))