Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format to display Years & Months

Status
Not open for further replies.

nickotine

Programmer
Nov 27, 2001
23
GB
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top