Diff2Dates
in [General]
|
From: youkr on 17 Mar 2010 23:38 Thank you everyone for your suggestions, I had thought by having a '0' in front of the single digit numbers I could then just use the Sort AZ in ascending order when needing to rearrange the data required, but the returning a value in seconds and not displaying it would work too. Thanks. "John Spencer" wrote: > If you want to sort in order, use a second call to generate the sort order, > you don't have to display this value, but you can sort by it. > > DateDiff("s",[FirstDate],[SecondDate]) > > That should return the number of seconds between the two dates so you can sort > by that and display the results of the Diff2Dates call. > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > youkr wrote: > > I have used the above function, however was wondering if there is a way I can > > change what is returned? > > At times I get records 1 day 10 hours 4 minutes, and other times 1 hour 8 > > minutes. When I try to place these returned records in ascendingdescending > > order according to this field they do not return in order as there is not a > > '0' before the '01' hours. Is there any way of doing this? > > > > The more I play aroudn the more questions I have!! > . > |