Hi in my straight table in qlikview i had a date fields in that it displaying date as number format like 41929.5416664 instead of displaying in date format this way 10/17/2014 13:00

[#1]

can any one please help me

[alexandros17]

Try with

Date(myDate)

let me know

[#3]

I tried by using that function but its not working and i also used date(date#) but this also not working

[r_wroblewski]

can you send a sample qvw?

[#5]

Hi,

Please, check you date format. Maybe date field is in number format. Change it to Date format using function: Date('Field_name', 'format').

Try this.

[amit_saini · Accepted solution]

Hi,

try this:

date(Your_date_Feild,'MM/DD/YYYY hh:mm') as Date_Key

Thanks,

AS

[arulsettu]

hi

try this

date(date#(datefield,'MM/DD/YYYY hh:mm') as Date

[r_wroblewski]

Hi

you also can try

Timestamp(yourdatefield, 'MM/DD/YYYY hh.mm')

Regards,

Ronny

[#9]

Thank u amit its working

[amit_saini]

Please mark this as correct or helpful answer to close the thread.

Thanks,
AS