topic Re: Convert date format to numeric in QlikView

Convert date format to numeric

pavanthota — Fri, 08 Jun 2012 14:46:50 GMT

Hi,

i have data in date format of one of my filed i want to convert the date format to numeric can anyone help me soon

The date format is mm/dd/yyyy(if the date is above 9th) otherwise mm/d/yyyy

Thanks,

Pavan

Convert date format to numeric

swuehl — Fri, 08 Jun 2012 15:17:22 GMT

Pavan,

if your dates field are of date data type, QV will hold the values with a textual as well as a numerical representation.

So if your standard date format is set to 'MM/D/YYYY' (at top of your script),

QV should automatically read in your date field as date data type, and you can calculate with dates.

For example

=num(DATEFIELD)

should show you the numerical representation.

Re: Convert date format to numeric

Miguel_Angel_Baeyens — Fri, 08 Jun 2012 17:27:10 GMT

Hi Pavan,

As Stefan points out, you will need to use the Num() function, and the Date#() format in case your local date format is not the same:

Num(Date#(Field, 'MM/DD/YYYY')) AS NumericDate

Hope that helps.

Miguel

Re: Convert date format to numeric

CELAMBARASAN — Fri, 08 Jun 2012 17:44:55 GMT

Hi,

Check with this

Num(DATE#(DateField,'MM/D/YYYY'))

Celambarasan

Re: Convert date format to numeric

pavanthota — Mon, 11 Jun 2012 12:28:54 GMT

Hi ,

I am new to the qlikview can anyone give me brief details on Date how it works in qlikview and date functions.

if it is any pdf or doc its more helpful

Thanks,

Pavan

Re: Convert date format to numeric

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 13:24:58 GMT

Hi Pavan,

You are lucky! Henric Cronström just wrote a very interesting blog post last week in regards to dates, very illustrative and detailed, that goes together this interesting PDF document. A must read if you want to know how dates work and why work the way they work in QlikView.

Hope that helps.

Miguel

Re: Convert date format to numeric

pavanthota — Thu, 14 Jun 2012 10:05:00 GMT

Hi Miguel,

Thanks for ur help its most valuable PDF for me. can u get a chance please take a look one of my post and give me reply

My Post Name: "Difference between MSQ and Standard

Re: Convert date format to numeric

Wed, 30 Dec 2015 11:08:58 GMT

Hi, Pavan.

As for me, I have seldom tried to convert the date format to numeric. I wonder have you ever worked it out? Do I need another 3rd party manual toolkit? When it comes to PDF converting process, I have another question, I wonder have you ever tried to convert pdf to other image files before? As for myself, I am testing the related PDF to PNG converting, PDF to BMP converting , and PDF to JPG converting programs these days. Do you have experience about it? Any suggestion will be appreciated. Thanks in advance.

Best regards,

Lee