Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I am using datediff to find the different but it appears only in minutes ! I want to separate different on days, Hours and Minutes !
This is what I am using =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only minutes appears I want difference in day, Hours and minutes something like that 2Days, 2Hours, 34Minutes
On Tue, 03 Nov 2009 04:05:01 -0800, Koulla wrote: > Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I > am using datediff to find the different but it appears only in minutes ! > I want to separate different on days, Hours and Minutes !
> This is what I am using > =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only > minutes appears I want difference in day, Hours and minutes something > like that 2Days, 2Hours, 34Minutes
> Thanks in advance > Koulla
There is no built in function in Access that does that. You could of course create a custom function in which you do the math yourself and return a text string in that format.
One of the regulars in these groups (I want to say Albert, but that could be wrong) has already written a function that does what you want. If you search these groups you might be able to find a post referring to it.
-- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
Rick Brandt wrote: > On Tue, 03 Nov 2009 04:05:01 -0800, Koulla wrote:
>> Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I >> am using datediff to find the different but it appears only in minutes ! >> I want to separate different on days, Hours and Minutes !
>> This is what I am using >> =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only >> minutes appears I want difference in day, Hours and minutes something >> like that 2Days, 2Hours, 34Minutes
>> Thanks in advance >> Koulla
> There is no built in function in Access that does that. You could of > course create a custom function in which you do the math yourself and > return a text string in that format.
> One of the regulars in these groups (I want to say Albert, but that could > be wrong) has already written a function that does what you want. If you > search these groups you might be able to find a post referring to it.
I bet that there's a better way, but it's all that I got. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Koulla" wrote: > Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I am > using datediff to find the different but it appears only in minutes ! > I want to separate different on days, Hours and Minutes !
> This is what I am using > =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only minutes > appears I want difference in day, Hours and minutes something like that > 2Days, 2Hours, 34Minutes
> I bet that there's a better way, but it's all that I got. > -- > Jerry Whittle, Microsoft Access MVP > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> "Koulla" wrote:
> > Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I am > > using datediff to find the different but it appears only in minutes ! > > I want to separate different on days, Hours and Minutes !
> > This is what I am using > > =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only minutes > > appears I want difference in day, Hours and minutes something like that > > 2Days, 2Hours, 34Minutes
|
