topic Re: Need help on date function in QlikView

Need help on date function

Thu, 20 Nov 2014 11:06:06 GMT

Hi,

In my tabls the field HIRE_DATE is in format DD/MMM/YYYY(10-Dec-2014).

How to convert this in to number format (DD/MM/YYYY) (10-12-2014)

i tried this but not worked out

Load

HIRE_DATE,

year(HIRE_DATE),

Month(HIRE_DATE),

week(HIRE_DATE),

Day(HIRE_DATE)

Resident EMP;

MarcoWedel — Thu, 20 Nov 2014 11:10:16 GMT

LOAD *,

Year(HIRE_DATE) as Year,

Month(HIRE_DATE) as Month,

Week(HIRE_DATE) as Week,

Day(HIRE_DATE) as Day;

LOAD Date(Date#(HIRE_DATE, 'DD-MMM-YYYY'),'DD-MM-YYYY') as HIRE_DATE

Resident EMP;

Thu, 20 Nov 2014 11:19:10 GMT

Hello Marcos,

Thanks for the solution.

MarcoWedel — Thu, 20 Nov 2014 11:20:55 GMT

You're welcome

regards

Marco