String into Date format

[dineshraj]

Hi all,

I got stuck in date formats.

My Input is "April"(from Apr to Mar) which is  string and Year 2017(2018) as another string

My output should look like

01/04/2017(in date format)

I have already tried of timestamp# and Date#

Can anybody help me to get out from this?

Thanks in advance

[tresesco · Accepted solution]

Full month name is parsed using 'MMMM'. So a string like : 'April 2017' can be parsed like:

Date(Date#('April 2017' , 'MMMM YYYY')) as Date

[dineshraj]

Hi Tresesco,

Its Working.Thanks for the fast reply