Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
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
sunny_talwar

Try this

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

qlikmpate0
Creator II
Creator II
Author

sorry no still displaying '-' (

sunny_talwar

How about this

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

qlikmpate0
Creator II
Creator II
Author

still the same

sunny_talwar

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

TRANSACTION_DATE

pradosh_thakur
Master II
Master II

what about

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

Learning never stops.
qlikmpate0
Creator II
Creator II
Author

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

sunny_talwar

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

qlikmpate0
Creator II
Creator II
Author

Please see attached for list boxes