Format to display Years & Months
Format to display Years & Months
(OP)
Hi All,
I have a filter in my report which gives me a Dwell time of how long a Asset has been in a location, dead simple it's current_date - [TRANSACTION_DATE], however when this is displayed on the report it gives something like '4956 days 9 hours 1 minute 39 seconds' against a record, I have been in the DATA properties of this field and no matter how I try I can't get it to Display YYYY-MM-DD. I need the result to display in YYYY-MM-DD. I have tried the Cast function but that keeps giving me errors. Any Help is much appreciated.
Clarky.
I have a filter in my report which gives me a Dwell time of how long a Asset has been in a location, dead simple it's current_date - [TRANSACTION_DATE], however when this is displayed on the report it gives something like '4956 days 9 hours 1 minute 39 seconds' against a record, I have been in the DATA properties of this field and no matter how I try I can't get it to Display YYYY-MM-DD. I need the result to display in YYYY-MM-DD. I have tried the Cast function but that keeps giving me errors. Any Help is much appreciated.
Clarky.
Talk To Other Members