Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Date(Floor(Date#(TRANSACTION_DATE, 'DD-MMM-YYYY hh:mm:ss'))) as TRANSACTION_DATE,
sorry no still displaying '-' (
How about this
Date(Floor(Date#(TRANSACTION_DATE, 'DD-MMM-YYYY'))) as TRANSACTION_DATE,
still the same
Can you share a list box when you load just this (without any manipulations)
TRANSACTION_DATE
what about
Date(Floor(Date#(TRIM(TRANSACTION_DATE), 'DD-MMM-YYYY'))) as TRANSACTION_DATE,
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
So, then you are all set, right? Dates are read as dates?
Please see attached for list boxes