May 23, 2003 #1 rhoneyfi MIS Joined Apr 8, 2002 Messages 200 Location US Easy question. I have CR 9.0 I have two dates that I want to calculate the date difference. I would like the format that is returned to be in years months days. Thanks
Easy question. I have CR 9.0 I have two dates that I want to calculate the date difference. I would like the format that is returned to be in years months days. Thanks
May 23, 2003 #2 dgillz Instructor Joined Mar 2, 2001 Messages 10,059 Location US 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 http://www.trianglepartners.com Upvote 0 Downvote
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 http://www.trianglepartners.com
May 23, 2003 #3 synapsevampire Programmer Joined Mar 23, 2002 Messages 20,180 Location US The datediff function would return all of the months/days, so you'd want to base those on the Remainder function. -k Upvote 0 Downvote
The datediff function would return all of the months/days, so you'd want to base those on the Remainder function. -k