Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yura_ratu
Partner - Creator II
Partner - Creator II

Getting Date from text

Hi everyone,

How can I get date from text in format 'MMM D, YYYY'?

For instance:

Apr 1, 2014

Apr 12, 2014

Thanks in advance

1 Solution

Accepted Solutions
Anonymous
Not applicable

try this if ur source format is 'MMM DD, YYYY' .

date(date#(DateField,'MMM DD, YYYY'),'D/M/YYYY') as DateFormatData,

View solution in original post

6 Replies
Anonymous
Not applicable

try

date(date#(DateText,'DD/MM/YYYY'),'MMM D, YYYY')

er_mohit
Master II
Master II

in which date format is your date now

like I have a date in DD/MM/YYYY form then

Try this

Date(DAte#(Datefield,'DD/MM/YYYY'),'MMM DD YYYY') AS Date

Anonymous
Not applicable

try this if ur source format is 'MMM DD, YYYY' .

date(date#(DateField,'MMM DD, YYYY'),'D/M/YYYY') as DateFormatData,

ThornOfCrowns
Specialist II
Specialist II

Duplicate of http://community.qlik.com/thread/114594

Please only post one version of your question to ensure that there's no duplication of effort and that a correct answer can be set properly.

rustyfishbones
Master II
Master II

it depends on what format your date is currently in.

Let's assume your date input is DD/MM/YYYY

You can then convert this by using

DATE(DATE#(Date,'DD/MM/YYYY'),'MMM D, YYYY') AS Date

rustyfishbones
Master II
Master II

Also please see the attached