Question: let's say in a customer table you have 2 fields , SubscribeDay & ExpiryDate. Is there way to have the ExpiryDate automatic fill,(add 1 month), the moment you key in SubscribeDay. On the same table
Question regarding this - this really did help me out since I am building a task for work where items mailed need to be reviewed after a certain time frame. However I don't see the data for the extra time frame (15 days added) being added into the master table column. Is there a trick to pushing that to the master table?
Good evening, I have a database with a table where among different fields, 3 are updated via query and one of these is a date field. Let me start by saying that I am a beginner and I was helped with the query. It works by updating the 3 fields but for the date one which is in short date format there is a problem. In practice, when I launch the query in the update for example from January to February it updates, but repeating the date 02/29/2024 twice more, then when updating from February to March I find the date 03/29/2024 repeated 3 times. Is there a way to prevent this from happening and get the months to update correctly? Thank you
Hi, I followed your instructions but it's not working for me. I want to add one year to a date and I followed yours perfectly and it keeps giving me an error. Can you help?? Thank you.
I get a ton of questions every day, and I don't have time to answer them all here on RUclips. Feel free to submit your question on my website at: 599cd.com/AskYT
Hi Richard. I have a Dateadd function in a query, which is supposed to give me 1 month + 7days after whatever end of month date is in another text box (VATDueDate: (DateAdd("m",1,[VAT Date]))+7). However, if the month is a 31 day one I get the 7th and 30 day one I get the 6th. I should get the 7th regardless. Would you know where I am going wrong? for example if the end of month date is 2022/11/30 then it returns 2023/01/06 but I expect 7th.
@Computer Learning Zone First of All, BIG thanks for your educating and informative videos. I recently started watching your videos to get some help in MS Access and they are really helpful, easy to understand and informative. Now, I have a question for you seeking some help on this video. It is an extension of this process. In my database, I have a due dates and associated repeat frequencies (Annual, Bi-Annual, 3 Year, 2 Year, Monthly, Bi Monthly, Qly etc.). With the help of your video I was able to create a query and calculate the next due date for each item but I am unable to figure out how to calculate all the next due dates for entire year. For e.g if an item repeats monthly I need the due dates for the next 12 months and so on based on the repeat frequency. Would really appreciate if you can help me with this.
@@599CD This is not what I was looking for. I guess I was not able to explain my requirement. Lets say I have a table with Item "A", Due Date 25 Nov 2020 and this item repeats quarterly. With the help of the query and "DateAdd" function I was able to show the next due date of 25 Feb 2021. What I am looking for is that when I run a query or use a formula it gives me the next 2 due dates as well. expected query result : Item A, Due Date 25 Nov 2020, Due Date1 25 Feb 2021, Due Date3 25 May 2021, Due Date4 25 Aug 2021.
@@599CD I guess I was not able to explain my requirement. Lets say I have a table with Item "A", Due Date 25 Nov 2020 and this item repeats quarterly. With the help of the query and "DateAdd" function I was able to show the next due date of 25 Feb 2021. What I am looking for is that when I run a query or use a formula it gives me the next 2 due dates as well. expected query result : Item A, Due Date 25 Nov 2020, Due Date1 25 Feb 2021, Due Date3 25 May 2021, Due Date4 25 Aug 2021.
what about time. Like calculating if employee time in early or late. im figuring i have to do something like DateDiff("n",[TimeIn],#9:00:00 AM#) but the numbers are weird. Im new to access.
Hi there, I have a question on how to determine month dates on loan repayment schedule in each month form the date disbursed for loans, How can this be achieved, please assist.
Access doesn't have a function that's equivalent to the Excel NETWORKDAYS function (to exclude weekends and holidays). I wrote one. It's in my Code Vault 599cd.com/CV and I also cover it in my DateTime Seminar: 599cd.com/DateTime
Omg! Googled for hours! Thank you this was too easy!
Welcome
Big thanks to this Big Guy. You are Great.
Thank you too!
thank you so much your videos are really helpful🥰
Glad you like them!
thank you very much sir Omar from Morocco.
You are welcome
God job Sir!!
Thanks
Question: let's say in a customer table you have 2 fields , SubscribeDay & ExpiryDate. Is there way to have the ExpiryDate automatic fill,(add 1 month), the moment you key in SubscribeDay. On the same table
Sure. See 599cd.com/AfterUpdate
Question regarding this - this really did help me out since I am building a task for work where items mailed need to be reviewed after a certain time frame. However I don't see the data for the extra time frame (15 days added) being added into the master table column. Is there a trick to pushing that to the master table?
You don't store that date in your table. You generate it with the query. Why store a date you can easily calculate?
Good evening, I have a database with a table where among different fields, 3 are updated via query and one of these is a date field. Let me start by saying that I am a beginner and I was helped with the query.
It works by updating the 3 fields but for the date one which is in short date format there is a problem.
In practice, when I launch the query in the update for example from January to February it updates, but repeating the date 02/29/2024 twice more, then when updating from February to March I find the date 03/29/2024 repeated 3 times. Is there a way to prevent this from happening and get the months to update correctly? Thank you
599cd.com/ask
Hi, I followed your instructions but it's not working for me. I want to add one year to a date and I followed yours perfectly and it keeps giving me an error. Can you help?? Thank you.
I get a ton of questions every day, and I don't have time to answer them all here on RUclips. Feel free to submit your question on my website at: 599cd.com/AskYT
Hi Richard. I have a Dateadd function in a query, which is supposed to give me 1 month + 7days after whatever end of month date is in another text box (VATDueDate: (DateAdd("m",1,[VAT Date]))+7). However, if the month is a 31 day one I get the 7th and 30 day one I get the 6th. I should get the 7th regardless. Would you know where I am going wrong? for example if the end of month date is 2022/11/30 then it returns 2023/01/06 but I expect 7th.
You're adding a whole month to the month end date. If you want to go from the FIRST of the month, then you need a different formula.
How would I specify the 19th of next month
599cd.com/DateSerial
hello, 10nk you for the video, is it possible to add working days?
i will check codevault, 10nx
599cd.com/DateTime OR 599cd.com/MyNetWorkDays
@Computer Learning Zone First of All, BIG thanks for your educating and informative videos. I recently started watching your videos to get some help in MS Access and they are really helpful, easy to understand and informative.
Now, I have a question for you seeking some help on this video. It is an extension of this process. In my database, I have a due dates and associated repeat frequencies (Annual, Bi-Annual, 3 Year, 2 Year, Monthly, Bi Monthly, Qly etc.). With the help of your video I was able to create a query and calculate the next due date for each item but I am unable to figure out how to calculate all the next due dates for entire year. For e.g if an item repeats monthly I need the due dates for the next 12 months and so on based on the repeat frequency. Would really appreciate if you can help me with this.
599cd.com/DateTime
@@599CD This is not what I was looking for. I guess I was not able to explain my requirement. Lets say I have a table with Item "A", Due Date 25 Nov 2020 and this item repeats quarterly. With the help of the query and "DateAdd" function I was able to show the next due date of 25 Feb 2021. What I am looking for is that when I run a query or use a formula it gives me the next 2 due dates as well. expected query result : Item A, Due Date 25 Nov 2020, Due Date1 25 Feb 2021, Due Date3 25 May 2021, Due Date4 25 Aug 2021.
@@599CD I guess I was not able to explain my requirement. Lets say I have a table with Item "A", Due Date 25 Nov 2020 and this item repeats quarterly. With the help of the query and "DateAdd" function I was able to show the next due date of 25 Feb 2021. What I am looking for is that when I run a query or use a formula it gives me the next 2 due dates as well. expected query result : Item A, Due Date 25 Nov 2020, Due Date1 25 Feb 2021, Due Date3 25 May 2021, Due Date4 25 Aug 2021.
what about time. Like calculating if employee time in early or late. im figuring i have to do something like DateDiff("n",[TimeIn],#9:00:00 AM#) but the numbers are weird. Im new to access.
599cd.com/ask
Hello. Why the day/month/year order is different there?
Because the USA has to do things differently than the rest of the world. Why? Who knows. It's dumb.
Hi there, I have a question on how to determine month dates on loan repayment schedule in each month form the date disbursed for loans, How can this be achieved, please assist.
Feel free to submit your question here: 599cd.com/TH
How can you exclude Saturday and Sunday with this method. How can it be done?
Access doesn't have a function that's equivalent to the Excel NETWORKDAYS function (to exclude weekends and holidays). I wrote one. It's in my Code Vault 599cd.com/CV and I also cover it in my DateTime Seminar: 599cd.com/DateTime