Use the DateDiff Function in an Access Query

[@Christine.Brown_RN_BSN]

I enjoy your videos and teaching style, Ralph. Thank you for taking the time to make them.

[@Con-menTv]

If this were to be used for start times and finish times and you need to calculate multiple start times and finish times on one form how would this be modified? Thanks awesome videos

[@brockmangroup9404]

Hello Ralph, I am trying to generate a select query to list all customers under 30 years old. When I use the datediff formula and select run I get the parameter box that pops up. Can you please help me on this?

[@Taylorejazmine]

Everytime I try to run this it asks me for a parameter for the dates, do you have any idea what the problem may be?

[@samuelwright2958]

@childofthespiral If you are using the newer version. It removed the need to underscore in categories. So, just putting a normal space resolves that issue instead of underscore

[@math260879]

In your example, the dates have the same year "2013". Whats about when the dates I want to calculate have different years? it works on the same statement or we have to change the statement on the Query?

[@bernman999]

Great video can you calculate the days out column For example can you Average the Days out ? how will that be done?

[@Forensource]

You have a good voice for narration.

[@muhammadfaruqbinmdyunus2137]

Thanks Ralph! The problem with this expression is that whenever I use it, Access says that it is "not valid for Web-compatible queries". How do I get around this? Thanks!

[@reymond21able]

Good day sir, can i ask some help for this issue.I try to use the datediff for the days elapsed.date elapsed:datediff("d",[dateassign],now()). to generate the pending days.The problem is, I want to erase the days elapsed or pending days automatically if i register the date of purchased.What code or formula do i need to use.

[@SixMinutesSmarter]

I've zipped the database and have made a link to that in the description. Give it a try.

[@math260879]

In your example, the dates have the same year "2013". Whats about when the dates I want to calculate have different years? it works on the same statement or we have to change the statement on the Query?

[@jadadocs8844]

Hi, thank you for the awesome video. Need some help, I am trying to work out a customer next service date. For example, a customer has their product serviced today and would like them to return on their next service interval which maybe 3/6/9 or 12 months intervals from today. I would like the "Next Service Date" that will add the selected month to the current date making that the next service due date. I need the information to auto-populate on a customer form as I am aware the formula can only be done on a query form. Hope you have a video which may help me with this.

[@urvilsheth1731]

Hi Ralph, thanks for this! I've tried inputting the DateDiff function as an expression for a calculated field. However, I cannot find the function (Access 2013). Please advise what to do, thanks!)

[@ana3671sosa]

Thanks you so much!!!! I was running crazy but now is done!

[@S-GShop]

Whenever i try to return the command it says "parameter value" how do i solve this problem?

[@sarahmccaslin-rice6326]

Did you ever figure this out? If so, any suggestions?

[@farmanalishah8836]

Nice Video. Dear Can you please explain how to find weekday name from two dates. I have two dates: Complain received date and Response received date. How to find weekday name?

[@qaisahmad3028]

can't download the demo database

[@divyabadineni2895]

Can anyone tell how to compare the table date time with system date time using sqldate function s with out creating variable....

[@moodkn]

Thanks Sir! Helpful

[@neetsbailey]

Thanks Ralph this really helped me

[@lipysak]

Days late:DateDiff("d",[Checkout_Date], [Return_Date]) You are welcome (y)

[@SupunWiratunga]

Thank you!

[@sherifadely9943]

thanks

[@COWBOY_TECH]

very helpful but hared to listen too you need to eq your audio to cut the sss and sharp highs in your voice hurts the ears

[@SripathiSanath]

How to find the dateDiff in minutes/ hours?

[@shwagdulla]

Thank you!