Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted

Try this

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

Highlighted
Creator II
Creator II

sorry no still displaying '-' (

Highlighted

How about this

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

Highlighted
Creator II
Creator II

still the same

Highlighted

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

TRANSACTION_DATE

Highlighted
Master II
Master II

what about

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

Learning never stops.
Highlighted
Creator II
Creator II

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

Highlighted

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

Highlighted
Creator II
Creator II

Please see attached for list boxes