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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Diff
- Thread starter rhoneyfi
- Start date
You woudl need to write 3 different datediff() functions, one to return years, one months and one days, and concatenate the results together.
Or you can download the UFL to do this from crystal decisions.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Or you can download the UFL to do this from crystal decisions.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
synapsevampire
Programmer
The datediff function would return all of the months/days, so you'd want to base those on the Remainder function.
-k
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question