What if you want to subtract two dates from within your table? For example, date received and date sent, I want to calculate the days difference between date received and date sent.
Good day Richard. I need to do a calculation between two dates: I have a delivery date and a cast date. The answer must tell me when 70% of the time between these dates has gone by and the item has not been cast yet
Subtract date1 from date2. That will give you the number of days between the two dates. Now multiply that by 0.7 and then add that number to date1. That will tell you your target date.
Dear Richard, Thank you for all your videos. I am viewing all your videos. It's really good to develop our skill set. Presently i am not able to displaying time zone based on the user selection I need help regarding setting the time according to the user's request. Based on User selection in the drop down list time should be display Ex: Bangalore-Bangalore Time zone New York - New York Time zone London - London Time zone San Francisco- San Francisco Time zone Thank you for your help... Regards, Mohan
Hello Richard I was wondering if it is possible to merge the Years Months and Days into this kind of format 1y3m2d just like this because in excel I was able to do this but how on access hoping you will able to help me thank's in advance.
Sir, i watch your videos regularly, i have searched Ms.access two date range with third text box query i mean specific person data but never found, i think no one worked on this can you make a video on it?
I'm not exactly sure what you're trying to do, but if you want me to make a video, submit it via the TechHelp page: 599cd.com/TechHelp - that's the best way to get on the list.
Hello Rick great content as usual but I am struggling with these full screen views. I much prefer your traditional small area views that are in all your courses.
hello, im using ms access2007, and using datediff, but everytime i run a command im getting "Undefined function 'DateDiff' in expression" i hope u can help me, thanks
I cover this in my Access Expert 28 class. I actually wrote a function called HowLong which can return values like "1 year, 3 months, 4 days." 599cd.com/XACX28
Hi how are you? I have question see if you could help me on Microsoft Access. I got two tables, one is Customer, one is current month order, how could I find out customers do not order this month. How do I set the criteria on the customer table to display those one not order this month. Hope you could help.
Doing it by month would be more difficult than just saying "show me customers who haven't ordered in 30 days." Set up an aggregate query to show MAX of the order date, and then use some date math like (Now()-OrderDate) to get the number of days since they last ordered. This is actually a good question for a video. Maybe I'll add it to my list...
dd: DateDiff("w",[Change Start Date],[Date Logged]) ..........want to work out the difference in workday (5day) but its not working on MS Access 2007, help please Change Start Date 06/06/2021 Date Logged = 20/04/2019
![เปิดบ้าน นาราเครปกระเทย 1 ไร่ ขายขาดทุนหลัก10ล้าน เอามาใช้หนี้!!! l [Nickynachat]](http://i.ytimg.com/vi/0jz84VFWVP4/mqdefault.jpg)
Hi Richard, thank you so much, you help me here in Brazil ;o)
Thank you Richard, this is exactly what I needed. Love your classes, friendly, easy and applicable right away.
Glad you like them!
Is it possible to make it in MS Access 2013?
@@599CD is it possible?
Excellent !! This is what I want .
Glad to help
Is there a way to use the DateDiff to display the difference in 2 dates in years, months, weeks, days, hours & mins in one string? Thx
Not easily. I do have a function that I wrote for this, however: 599cd.com/HowLong
Very, very helpful. Thank you!
You're welcome!
What if you want to subtract two dates from within your table? For example, date received and date sent, I want to calculate the days difference between date received and date sent.
599cd.com/ask
Good day Richard. I need to do a calculation between two dates: I have a delivery date and a cast date. The answer must tell me when 70% of the time between these dates has gone by and the item has not been cast yet
Subtract date1 from date2. That will give you the number of days between the two dates. Now multiply that by 0.7 and then add that number to date1. That will tell you your target date.
Dear Richard,
Thank you for all your videos. I am viewing all your videos. It's really good to develop our skill set.
Presently i am not able to displaying time zone based on the user selection
I need help regarding setting the time according to the user's request.
Based on User selection in the drop down list time should be display
Ex: Bangalore-Bangalore Time zone
New York - New York Time zone
London - London Time zone
San Francisco- San Francisco Time zone
Thank you for your help...
Regards,
Mohan
Working across time zones can be tricky. I'll try to put together a lesson on this in the near future.
i love your tutorial video. God bless.
Thank you! 😊
Hello Richard I was wondering if it is possible to merge the Years Months and Days into this kind of format 1y3m2d just like this because in excel I was able to do this but how on access hoping you will able to help me thank's in advance.
Sure. Just use the Format function and some concatenation.
Is there any way to calculate the year differences instesd of the day?
You mean like 599cd.com/Age?
Sir, i watch your videos regularly, i have searched Ms.access two date range with third text box query i mean specific person data but never found, i think no one worked on this can you make a video on it?
I'm not exactly sure what you're trying to do, but if you want me to make a video, submit it via the TechHelp page: 599cd.com/TechHelp - that's the best way to get on the list.
Thank you Richard stay positive hope your heath improves
Thank you.
Thank you for this sir, just what I needed
Glad it helped
Hello Rick great content as usual but I am struggling with these full screen views. I much prefer your traditional small area views that are in all your courses.
Yeah, sorry about that Chris. Had to join the 21st Century though and go HD. I think the videos are much clearer now.
Thanks for this sir!
Welcome!
I'm looking to calculate age as of 12/31 current year. Is there a way to calculate without having to hard code 12/31/yyyy? Thanks
You could say:
MyStr = "12/31/" & Year(Date())
MyDate = CDate(MyStr)
hello, im using ms access2007, and using datediff, but everytime i run a command im getting "Undefined function 'DateDiff' in expression" i hope u can help me, thanks
Well, DateDiff has been around for ages, definitely since 2007. How/where are you using it?
Dear Sir I want to calculate age in access report as "01 years, 2 Months, 3 Days" format
I cover this in my Access Expert 28 class. I actually wrote a function called HowLong which can return values like "1 year, 3 months, 4 days." 599cd.com/XACX28
i want access office like yours. where can i get it?
I have a Microsoft 365 for Business subscription. amzn.to/3alIJLm
Nice topic ! So How Extract Day Name from date field ?????
Easiest way is the use the FORMAT Function: Format(MyDate,"dddd") will give you "Wednesday". I cover this in Access Expert 11: 599cd.com/X2VJN
@@599CD Thk's very much!
Hi how are you? I have question see if you could help me on Microsoft Access. I got two tables, one is Customer, one is current month order, how could I find out customers do not order this month. How do I set the criteria on the customer table to display those one not order this month. Hope you could help.
Doing it by month would be more difficult than just saying "show me customers who haven't ordered in 30 days." Set up an aggregate query to show MAX of the order date, and then use some date math like (Now()-OrderDate) to get the number of days since they last ordered. This is actually a good question for a video. Maybe I'll add it to my list...
please tell me how to get total numer of a given month as in ms excel EOMONTH
I actually have a video on this coming soon.
Thanks great sir.
@@599CD
599cd.com/EOMONTH
Sir, I want to calculate the Year, Month & Days from Date of Birth. Please explan the way to get actual age. Regards
599cd.com/age
dd: DateDiff("w",[Change Start Date],[Date Logged]) ..........want to work out the difference in workday (5day) but its not working on MS Access 2007, help please Change Start Date 06/06/2021
Date Logged
= 20/04/2019
DateDiff with a "w" gives you whole 7-day weeks, not 5-day work weeks.
thumbs up
Thanks!