Question Report Question Regarding DateDiff

[Steve_T]

Hi i have a Textbox called DateTimeGiven which CONCATENATION the Date and TIME: =[DateDefectGivenToEngineer] & " " & [TimeDefectGivenToEngineer]
and another one that does the same: DateTimeReported: =[DateReportedToRepairServices] & " " & [TimeReportedToRepairServices].

I am trying to find the difference between them both using =DateDiff("n",[DateTimeReported],[DateTimeGiven])\60 & ":" & Format(DateDiff("n",[DateTimeReported],[DateTimeGiven]) Mod 60,"00")

When i run the report i seems that the data cant be seen and Access asks for values for the both mentioned boxes. i have checked the CONCATENATION and they work fine its just the DateDiff's

Can anyone help????

 

[Uncle Gizmo]

DateValue function Video

One cause of this particular problem is that the date may not be actually a date, it may be a date/time. If it is you need to use the DateValue function to extract the date portion and then use that. There is a video here which gives you further information:

 

[Steve_T]

Yes i can see the problem now, your right it was down to the format.
Thanks it works fine now