Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Handle this date "June 1, 2014"

Hello,

I have a date format like this:

"June 1, 2014"   (date is a string and comma is inside)

I have tried this function but it doesn't work:

Date#(Date,'MMMM D YYYY')


Could anyone help me?

My best regards

1 Solution

Accepted Solutions

Re: Handle this date "June 1, 2014"

TRY BELOW

=DATE(Date#(Date,'MMMM D, YYYY'),'MMMM D YYYY')

Regards

ASHFAQ

2 Replies

Re: Handle this date "June 1, 2014"

TRY BELOW

=DATE(Date#(Date,'MMMM D, YYYY'),'MMMM D YYYY')

Regards

ASHFAQ

Not applicable

Re: Handle this date "June 1, 2014"

It works !!

Thank you very much

Community Browser