Time difference between 2 fields with dates

[Dissander]

Dear Team,
I have a table with 2 fields with dates - TestDate & ReceptionDate. I'd like to get the time difference between the TestDate & receptionDate - Basically, how long it took to do a test. Table attached.
Thank you. Much appreciated.

 

[Ranman256]

For days, use D
DateDiff("d",date1,date2)

Hours= h
Months=m
Etc...

 

[Dissander]

Thank you Ranman256. Date1 = [RequestDate]?

 

[Dissander]

It worked. Thank you.