topic Change date format included right function in QlikView

Change date format included right function

Anonymous — Fri, 22 Jun 2012 06:04:49 GMT

Hello,

I have one field named PROFILE. That field returns the following data:

000673/2012.04.01. The first characters are staffnumbers en the others are date of making the staffnumbers

I don't want to use the staffnumbers

How can i change only the 2012.04.01 to a date that i used in my application D-M-YYYY

Thank you

rohit214 — Fri, 22 Jun 2012 06:16:12 GMT

hello.

try this

=right(000673/2012.04.01. ,11) as date

and front end date(2012.04.01,'dd-mm-yyyy')

or chane formate in your script SET DateFormat='DD-MM-YYYY';

thanks&regards

rohit

Jason_Michaelides — Fri, 22 Jun 2012 06:17:24 GMT

Hi,

Try:

Date(Date#(SubField(PROFILE,'/',2),'YYYY.MM.DD'),'D-M-YYYY') AS Date

Hope this helps,

Jason