Date and time displaying as null

[qlikmpate0]

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.

[sunny_talwar]

Try this

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

[qlikmpate0]

sorry no still displaying '-' (

[sunny_talwar]

How about this

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

[qlikmpate0]

still the same

[sunny_talwar]

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

TRANSACTION_DATE

[pradosh_thakur]

what about

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

[qlikmpate0]

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]

Please see attached for list boxes