DateFormat problem in machines

[#1]

Hi all,

In my application having a field CaptureDateTime and displays data in "Date" format(M/D/YY) in listbox

but when i'm using it in straight table with another field as calculated dimension then instead of displaying in "Date" format it is displaying in "Number" format.

Please find the attached application.

[giakoum · Accepted solution]

Date is only a formatting function, so in order to see it correctly, you need to reapply Date in your dimension :

=date(CaptureDate) &' '& Pick(WildMatch(vTimeRange,'5*','10*'),[5mins],[10mins])

But still it it stored as a number in QlikView

[#3]

hi

simply write

Date(fieldname)