Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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