Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qlikmpate0
Contributor II

Date and time displaying as null

I have a field which is a date field, I have tried various formats to display the date or date and time, but in my table is it showing, but in my UI it is displaying as a null, how can this be rectified?

Date(Floor(TRANSACTION_DATE),'DD-MMM-YYYY hh:mm:ss') as TRANSACTION_DATE,

Floor(TRANSACTION_DATE) as TRANSACTION_DATE,

Date#(Floor(TRANSACTION_DATE),'DD-MMM-YYYY hh:mm:ss') as TRANSACTION_DATE,

Date(TRANSACTION_DATE) as TRANSACTION_DATE,



Can someone advise, as I'm pulling my hair out.

18 Replies

Re: Date and time displaying as null

Try this

Date(Floor(Date#(TRANSACTION_DATE, 'DD-MMM-YYYY hh:mm:ss'))) as TRANSACTION_DATE,

qlikmpate0
Contributor II

Re: Date and time displaying as null

sorry no still displaying '-' (

Re: Date and time displaying as null

How about this

Date(Floor(Date#(TRANSACTION_DATE, 'DD-MMM-YYYY'))) as TRANSACTION_DATE,

qlikmpate0
Contributor II

Re: Date and time displaying as null

still the same

Re: Date and time displaying as null

Can you share a list box when you load just this (without any manipulations)

TRANSACTION_DATE

pradosh_thakur
Honored Contributor II

Re: Date and time displaying as null

what about

Date(Floor(Date#(TRIM(TRANSACTION_DATE), 'DD-MMM-YYYY'))) as TRANSACTION_DATE,

Learning never stops.
qlikmpate0
Contributor II

Re: Date and time displaying as null

the transaction_date list box is showing dates with grey check boxes. this is when i'm using  this formula

Date(TRANSACTION_DATE) as TRANSACTION_DATE

Re: Date and time displaying as null

So, then you are all set, right? Dates are read as dates?

qlikmpate0
Contributor II

Re: Date and time displaying as null

Please see attached for list boxes