Formatting of date field

[#1]

Hi everyone,

I am hoping someone can help me as I am a little confused.

I have a date field that is pulled though into my document and if I use this field as it is, Qlikview will then allow me to change the format of this in the Number tab in the properties to the format I want (dd/mm/yyyy). But when I put an expression on this field it now does not show in the number tab for me to format and shows as the number it relates to eg. 40725 = 01/07/2011.

Would anyone be able to help me to get the date displaying correctly and let me know where I am going wrong.

The formula I have added is:-

=if(unit_crew1=unit_crew1_PIN, full_date,

    if(unit_crew2=unit_crew2_PIN, full_date,

     if(unit_crew3=unit_crew3_PIN, full_date,

I have done this as I need to pull through details of staff names and if I dont add something it then shows details that don't relate to the individual as they have been on the incident but not the person that has fullfilled a specific part of the job. This seems to have solved part of my problem but caused another.

Thanks for any help

      Null())))

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

if(unit_crew1=unit_crew1_PIN, date(full_date,'DD/MM/YYYY'),

    if(unit_crew2=unit_crew2_PIN, date(full_date,'DD/MM/YYYY'),

     if(unit_crew3=unit_crew3_PIN, date(full_date,'DD/MM/YYYY'),

Regards,

Kaushik Solanki

[SunilChauhan]

while pulling in script

Load

;;

;

;

;

;

;

date(full_date,'DD/MM/YYYY') as full_date,// add this line to ur code

;

;

;

;

;

from path