topic Re: How to change date format to number format ?? in QlikView

How to change date format to number format ??

skr002244 — Mon, 05 Jan 2015 04:30:52 GMT

how to change

22/10/2015

11/11/2015

25/12/2015

into number format ?

Mon, 05 Jan 2015 04:38:31 GMT

Hi ,

Try this

num('22/10/2015')

Thanks

Harsha

Anonymous — Mon, 05 Jan 2015 04:47:29 GMT

Hi,

Num(date_field) gives u the answer

HTH.

avinashelite — Mon, 05 Jan 2015 04:49:40 GMT

Hi Santha,

Use Date#(date_field) to convert date to other format.

To format date field use Date() function.

Anonymous — Mon, 05 Jan 2015 04:51:01 GMT

Hi Try like this

=Num(Today()) gives the number as 42009

Like wise use in u r requirement

skr002244 — Mon, 05 Jan 2015 04:52:58 GMT

if 17/9/2015 is in char format then how to change it ?

Anonymous — Mon, 05 Jan 2015 04:56:12 GMT

Use num(date(date#('17/9/2015','dd/mm/yyyy')))

skr002244 — Mon, 05 Jan 2015 05:13:55 GMT

if i want to have multiple date format like d/m/yyyy ???

jagan — Mon, 05 Jan 2015 05:16:09 GMT

Hi,

Then try like this using Alt()

=Alt(Date#(DateField, 'd/M/yyyy'), Date#(DateField, 'M/d/yyyy'),Date#(DateField, 'd/MMM/yyyy'), ...............

)

Regards,

Jagan.