topic Re: Converting Date format in QlikView

Converting Date format

rido1421 — Mon, 08 Sep 2014 09:57:56 GMT

Hi There

I need to convert the date format on the following date field.

Trim(Replace([lst pym dt],'.','')) as [lst pym dt]

The result of this is 01042014

I need my result to be 20140401

further on in my script I need to be able to multiply the Year, by 100

if(Year(Trim(Replace([lst pym dt],'.','')))* 100 +Month(Trim(Replace([lst pym dt],'.',''))= '201401',[Payment],0)

Thank you.

avinashelite — Mon, 08 Sep 2014 09:59:43 GMT

Hi ,

try like this:

Date(expression, 'YYYYMMDD')

sushil353 — Mon, 08 Sep 2014 10:00:40 GMT

Try this:

Date(Date#(Trim(Replace([lst pym dt],'.','')),'DDMMYYYY'),'YYYYMMDD')

HTH

Sushil

ashfaq_haseeb — Mon, 08 Sep 2014 10:01:32 GMT

Hi,

Try this.

date(date#(Trim(Replace([lst pym dt],'.','')),'DDMMYYYY'),'YYMMDD') as [lst pym dt]

Regards

ASHFAQ

deepakqlikview_123 — Mon, 08 Sep 2014 10:01:44 GMT

try

Date(Date#([lst pym dt],'MM-DD-YYYY'),'YYYY-MM-DD')

MK_QSL — Mon, 08 Sep 2014 10:08:11 GMT

Date(Date#(Trim(Replace([lst pym dt],'.','')) ,'DDMMYYYY'),'YYYYMMDD') as [lst pym dt]