Date Formatting

[#1]

Hi All,

I am using Qlikview10.

I have a Date field in my table but it is in string format.

I have to arrange the report By Week. I have an excel sheet where year, week, fdate, ldate fields are there which indicate that which date falls on which week of which year.

But I can't able to understand how to implement this to my report/table.

Please Suggest.

[its_anandrjs]

Hi,

I am not able to reload your table but its okay yes as Simmons say you need to join the fields or use @3 as a field to make date use this

Load

Makedate( Left( @3, 4 ), Mid( @3, 5 , 2 ),Right( @3, 2 ) ) as Date

Resident Tab1;

Regards,

Anand

[#3]

Perfect.

Thanks Simmons and Anand.

Your work is really appreciable.

[#4]

Anand - do you have any suggestions on how to format a date that looks like this 11912 to be 1/19/2012?

[Anonymous]

Hi,

Use the following example of Load statement

LOAD

     Date,

     Year(Date) AS Year,

     Month(Date) AS Month,

     Day(Date) AS Day

     '

     '

     ';

LOAD

     Date(Date#(DateField, 'YYYYMMDD')) AS Date

'

'

'

'

FROM ABC.txt;    

In the above script you can arrive the Year, Month, Day and Date in valid format.  By using Month, Year and Day dimensions you can create the charts.

[jagan]

Hi,

Use Date#()

=Date(Date#(DateFieldName, 'MDDYY'), 'M/DD/YYYY')

Hope this helps you.

Regards,

Jagan.