How to change date format in qvw

[#1]

Hi,

I have date column in sql table like below

Oct 22 2008 12:00AM

I need to have date in qlikview application as 2008/10/22

Could anyone help me how to write in script.

Thanks

[tresesco · Accepted solution]

Try like:

Load

          Date(Date#(FieldFromDB, 'MMM DD YYYY hh:mmTT'), 'YYYY/MM/DD') as NewDate

;

SQL Select

  '''

From <>;

[MayilVahanan]

Hi

Try like this

Instead of Oct 22 2008 12:00AM -> Use your datefield

Date(Date#('Oct 22 2008 12:00AM','MMM DD YYYY hh:mmTT'),'YYYY/MM/DD')

[#4]

Load

          Date(Date#(FieldFromDB, 'MMM DD YYYY hh:mm TT'), 'YYYY/MM/DD') as New_Date;

SQL Select

  '''

From <>;

This should work.

[#5]

[#6]

Thanks and it's working but I can able to see 2059/09/12 and 2069/19/01 and not able to see the date 29/09/2013 which exists in ly table. Please help in this

[#7]

Thanks and it's working but I can able to see 2059/09/12 and 2069/19/01 and not able to see the date 29/09/2013 which exists in ly table. Please help in this

[tresesco]

Ideally, there should have been a space before 'TT'. Try and let know if that was the issue.

[#9]

Yup.

And thats what I posted.