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
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
Its Working.Thanks for the fast reply
Retrieving data ...