how to change the string format ?

[Anonymous]

Hi ,

I have a date field(Date) as OBJ_GDN_Date which is coming from excel but when i am loading the date field to qlikview it is displaying as  41729.

Can any one help me how to change it Date format.

Regards,

Sharma.

[stevedark]

Hi Sharma,

As a matter of fact, I do, details are here:

http://www.quickintelligence.co.uk/training/

Thanks,

Steve

[Anonymous]

Ok Thanks steve.

[Anonymous]

Hi Steve,

I am checking a qvd which has loaded the data from excel but i deliberately making one of  the date fields in excel in a wrong format to check if the code below is working or not.but i am getting error as i=1 error and next i as error.

and its not checking the condition .

Can you help me pls.

SET vDate = 'OBJ_GSoSEndDate';//This is my field name coming from the excel which holds date field//

trace $(vDate);

LET vNumRows=NoOfRows('GS1');//This  GS1 is my Table.

FOR  i =1  to $(vNumRows)

  let vFieldvalue = FieldValue('OBJ_GSoSEndDate', $(i));

  trace $(vFieldvalue);

  let vDate1 = Date(Date#(vFieldvalue,'DDMMYYYY'), 'DD/MM/YYYY');

  IF '$(vFieldvalue)' =  '$(vDate1)' or '$(vDate1)' = '' then

  trace Dates Match;

  ELSE

  trace dates dont match;

  ENDIF

NEXT i;

Pls help me

Regards,

Sharma.