Convert String to Date

[#1]

Hello,

I have the following Date as a String:

01/08/2016 03:00 (DD/MM/YYYY hh:mm)

What I need is to convert it to Date in order to show the month like this: August

Do you know how to do that?

Thank you!

[trdandamudi]

May be as below:

[sunny_talwar]

May be like this:

Date(Date#(DateField, 'DD/MM/YYYY hh:mm')) as Date,

Month(Date#(DateField, 'DD/MM/YYYY hh:mm')) as Month,

Date(MakeDate(Year(Today()), Num(Month(Date#(DateField, 'DD/MM/YYYY hh:mm'))), 1), 'MMMM') as FullMonthName