@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
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?
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
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?
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?
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!)
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.
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!
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.
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?
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.7 (1/4)](http://i.ytimg.com/vi/2rPGOyKs0VE/mqdefault.jpg)
I enjoy your videos and teaching style, Ralph. Thank you for taking the time to make them.
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?
@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
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?
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
I've zipped the database and have made a link to that in the description. Give it a try.
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?
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?
You have a good voice for narration.
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!)
Great video can you calculate the days out column For example can you Average the Days out ? how will that be done?
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.
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!
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.
Whenever i try to return the command it says "parameter value" how do i solve this problem?
Did you ever figure this out? If so, any suggestions?
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?
Can anyone tell how to compare the table date time with system date time using sqldate function s with out creating variable....
can't download the demo database
Thanks Sir! Helpful
Thanks Ralph this really helped me
Thanks you so much!!!! I was running crazy but now is done!
Thank you!
How to find the dateDiff in minutes/ hours?
Days late:DateDiff("d",[Checkout_Date], [Return_Date])
You are welcome (y)
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
thanks
Thank you!