topic Re: how to convert actual date format in QlikView

how to convert actual date format

madhubabum — Tue, 30 Jun 2015 08:50:48 GMT

Hi all

How to convert 42185 to actual date format

Re: how to convert actual date format

jsingh71 — Tue, 30 Jun 2015 08:53:48 GMT

Date(<Date_Field>,'MM/DD/YYYY')

During Load

Date(<Date_Field>,'MM/DD/YYYY') as <NewFieldName>

As per your Example:

=Date('42185', 'MM/DD/YYYY')

Output: 06/30/2015

Re: how to convert actual date format

alexandros17 — Tue, 30 Jun 2015 08:53:54 GMT

Date(42185)

let me know

Re: how to convert actual date format

arulsettu — Tue, 30 Jun 2015 08:53:58 GMT

try this

=Date('42185')

Re: how to convert actual date format

krishna20 — Tue, 30 Jun 2015 09:08:04 GMT

Hi,

If you wanna see simple date format of your date field. Take that field in the list box.Go to properties->

Number->override Document Settings-> select Date/.

Re: how to convert actual date format

Gabriel — Tue, 30 Jun 2015 09:10:41 GMT

Hi,

If you wanted to convert it Numeric value from the script to date or in UI do DATE(42185).

This should give you date format according to how you've define your date format from the GLOBAL variable in the script

Re: how to convert actual date format

vardhancse — Tue, 30 Jun 2015 09:12:50 GMT

Date(Floor(42185))

o/p: 30/06/2015

Re: how to convert actual date format

Tue, 30 Jun 2015 09:15:06 GMT

Re: how to convert actual date format

sunilkumarqv — Tue, 30 Jun 2015 09:16:07 GMT

try like this

Date(Date#(DateField,'MM/DD/YYYY'))

Re: how to convert actual date format

SatyaPaleti — Tue, 30 Jun 2015 09:52:42 GMT

Hi Sunil,

Date(Floor(42185)) as Date

Thank you,

SatyaPaleti

Re: how to convert actual date format

buzzy996 — Tue, 30 Jun 2015 10:10:15 GMT

see tis,

Re: how to convert actual date format

Tue, 30 Jun 2015 14:02:17 GMT

Very helpful post. Was facing the same issue