topic Re: Convert String to Date in QlikView

Convert String to Date

anuradhaa — Wed, 10 Feb 2016 08:19:48 GMT

HI ,

I have this string and i want to convert it to Date,

Jan, 04

Thanks

Re: Convert String to Date

settu_periasamy — Wed, 10 Feb 2016 08:26:06 GMT

Try

=MonthStart(Date#('Jan, 04','MMM, YY'))

Re: Convert String to Date

Mark_Little — Wed, 10 Feb 2016 08:28:02 GMT

Hi,

How is the date formatted?

I.e.

Is it month year January 2014

or 4th January

Also how do you want it to be formatted?

01/01/2004?

Mark

Re: Convert String to Date

Anonymous — Wed, 10 Feb 2016 08:32:04 GMT

Can you please trying this convert option!

=Date(Date#(Jan, 04,'mmm,DD'),'DD/MM')

Re: Convert String to Date

its_anandrjs — Wed, 10 Feb 2016 08:32:42 GMT

Try this ways

=Date(Date#('Jan, 04','MMM, DD'),'MMM, DD')

Regards

Anand

Re: Convert String to Date

sunny_talwar — Wed, 10 Feb 2016 08:41:51 GMT

What format are you trying to convert it into?

May be this:

Date(Date#(DateField, 'MMM, YY'), 'YourDesiredDateFormatHere') as Date

Re: Convert String to Date

ramasaisaksoft — Wed, 10 Feb 2016 08:44:42 GMT

Hi Anu,

select that field into any object and Number format choose as your wish.

else in code level you need to write

Date#(Start_Date,'MM/DD/YYYY') as Start_Date -->converts string to date format

Date(Date#(Start_Date,'MM/DD/YYYY'),'YYYY/MMM/DD') as Start_Date--> Converts date format data into your convenient date format

Re: Convert String to Date

HirisH_V7 — Wed, 10 Feb 2016 09:24:40 GMT

Hi,

Check this,

Date:
LOAD *,


Mid(Date,1,3)  as Month,
'20'&Mid(Date,6,8)  as year,
'01/'& Mid(Date,1,3) & '/20'&Mid(Date,6,8) as DateField,
Date#('01/'& Mid(Date,1,3) & '/20'&Mid(Date,6,8),'DD/MM/YYYY') as DateField1


 INLINE [
    Date
    "Jan, 04"
];

can you tell me your exact date format required.

-Hirish

Re: Convert String to Date

Wed, 10 Feb 2016 10:23:28 GMT

Hi Anuradha,

Try this,

Date(Date#('Jan, 04','MMM, YY'),'MM/DD/YYYY') if you want date in MM/DD/YYYY format.

You can give other formats according to your requirement.

Regards

Re: Convert String to Date

luizcdepaula — Thu, 10 Mar 2016 15:46:11 GMT

If it is simply a text field, not date formatted already, the syntax above from Lokeshwari works perfectly.

Thanks