DATE/WEEK extraction from a column in format yy-mm-dd

[Uma7]

Hi,

i have a column creation date in format yymmdd from which i need to extract date and weekly data to make graphs.

how can this be done?

can anyone help me?

Thanks in advance!

[tresesco]

Try like:

Date(Date#([Creation Date], 'yymmdd')) as Date,

Week(Date#([Creation Date], 'yymmdd')) as Week

[Uma7]

Its not working 
btw- my creation date column is of string type 

[tresesco · Accepted solution]

Date#() parses string to date value. Then may be you should try like:

Date#([Creation Date], 'YYMMDD')

[Uma7]

when i try the expression is ok but no data for date is displayed

[tresesco]

That could potentially mean that your date values are not really in YYMMDD format. Try reloading the field directly in qlik, and see how exactly your data is read by qlik, and then use parsing format accordingly. Please note, additional spaces could also create problem.

[srchagas]

Try to Use:

On load script: 

 Date(Date#([Creation Date],'YYYYMMDD'),'YYMMDD') as [Creation Date]