topic DateFormat problem in machines in QlikView

DateFormat problem in machines

Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: DateFormat problem in machines

giakoum — Thu, 21 Feb 2013 10:40:49 GMT

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

Re: DateFormat problem in machines

Thu, 21 Feb 2013 10:48:40 GMT

simply write

Date(fieldname)