DateDiff Conversion
in [Queries]
|
Prev: using dates
Next: Multi List combo as criteria
From: Reggie on 24 Mar 2010 19:27 Hi and TIA. I have a query that is getting the datediff between to date/timestamp fields. If the difference is 6days and 5 hrs I was wondering if it is possible to have the result show as 6d and 5h. Thanks! -- Reggie
From: John W. Vinson on 24 Mar 2010 20:16 On Wed, 24 Mar 2010 16:27:57 -0700, "Reggie" <No_Spam_chief123101(a)yahoo.com> wrote: >Hi and TIA. I have a query that is getting the datediff between to >date/timestamp fields. If the difference is 6days and 5 hrs I was wondering >if it is possible to have the result show as 6d and 5h. Thanks! Not directly with DateDiff, without some extra coding; but... See Doug Steele and Graham Seach's Diff2Dates function: http://www.accessmvp.com/djsteele/Diff2Dates.html -- John W. Vinson [MVP]
From: Mr. Bud on 24 Mar 2010 20:50 "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:vpalq5t406ebc8qe82l37v0mmlbkuirhbu(a)4ax.com... > On Wed, 24 Mar 2010 16:27:57 -0700, "Reggie" > <No_Spam_chief123101(a)yahoo.com> > wrote: > >>Hi and TIA. I have a query that is getting the datediff between to >>date/timestamp fields. If the difference is 6days and 5 hrs I was >>wondering >>if it is possible to have the result show as 6d and 5h. Thanks! > > Not directly with DateDiff, without some extra coding; but... See Doug > Steele > and Graham Seach's Diff2Dates function: > > http://www.accessmvp.com/djsteele/Diff2Dates.html > > -- > > John W. Vinson [MVP] John, Me again. Thanks for the link -- Reggie
From: Mr. Bud on 24 Mar 2010 23:55 "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:vpalq5t406ebc8qe82l37v0mmlbkuirhbu(a)4ax.com... > On Wed, 24 Mar 2010 16:27:57 -0700, "Reggie" > <No_Spam_chief123101(a)yahoo.com> > wrote: > >>Hi and TIA. I have a query that is getting the datediff between to >>date/timestamp fields. If the difference is 6days and 5 hrs I was >>wondering >>if it is possible to have the result show as 6d and 5h. Thanks! > > Not directly with DateDiff, without some extra coding; but... See Doug > Steele > and Graham Seach's Diff2Dates function: > > http://www.accessmvp.com/djsteele/Diff2Dates.html > > -- > > John W. Vinson [MVP] John, me again. Got the function working with the link you sent . Now was wondering if it's possible to get an average from the result? I keep getting data type mismatch(which don't surprise me). My results are like: 21d 3h 15d 5h etc. Don't know if its possible but thought I'd ask. Thanks! -- Reggie
From: Mr. Bud on 25 Mar 2010 00:50
"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:vpalq5t406ebc8qe82l37v0mmlbkuirhbu(a)4ax.com... > On Wed, 24 Mar 2010 16:27:57 -0700, "Reggie" > <No_Spam_chief123101(a)yahoo.com> > wrote: > >>Hi and TIA. I have a query that is getting the datediff between to >>date/timestamp fields. If the difference is 6days and 5 hrs I was >>wondering >>if it is possible to have the result show as 6d and 5h. Thanks! > > Not directly with DateDiff, without some extra coding; but... See Doug > Steele > and Graham Seach's Diff2Dates function: > > http://www.accessmvp.com/djsteele/Diff2Dates.html > > -- > > John W. Vinson [MVP] John, Basically what I'm trying to do and have been combing the network/help files for is I have a totals query grouped by supplier. I have a order date and delivery date. I'm trying to get an average time it takes for the delivery in Days:Hrs. I'm getting a result like 25.6. I know the 25 is 25days. Question is what does the .6 mean. Is it 6/10 of an hr or 6 hours out of 24 or am I way off base here. Probably a dumb answer, but never said I was the sharpest crayon in the box ;-). -- Reggie |