Search found 89 matches
- Wednesday 4th January 2023 1:47pm
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
Re: What is the easiest way to get years, months and days?
Hi BruceS With your permission, I have corrected the code because it fails with this date: DD/MM/YYYY 04/01/2023 02/01/2026 Public Sub TimeSpan(date1 As String, date2 As String) As String Dim d1 As Date = CDate(Val(date1)) Dim d2 As Date = CDate(Val(date2)) Dim yr, mn, dy, add As Integer yr = DateDi...
- Sunday 1st January 2023 9:58pm
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
Re: What is the easiest way to get years, months and days?


Ole !!!
For me you are a machine. Thank you for your masterful solution
- Sunday 1st January 2023 8:17pm
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
Re: What is the easiest way to get years, months and days?
I am going to give you dates calculated by the web provided previously. DD/MM/YYYY 10/12/2022 - 29/12/2022 0 year, 0 month, 19 days (Ok) 19/10/2021 - 09/12/2022 1 year, 1 month, 21 days (Ok) 26/09/2015 - 14/06/2021 5 year, 8 month, 20 days (Ok) 29/09/1998 - 04/10/2021 23 year, 0 month, 6 days (Ok)
- Sunday 1st January 2023 8:02pm
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
Re: What is the easiest way to get years, months and days?
Hi BruceS Your code does not work well for me, it leaks everywhere, try the date that I have given as an example of: DD/MM/YYYY 10/12/2022 29/12/2022 My code works but I don't know if it is exact in the calculations. I am going to count the days, months and years in case it is valid. Note: I promise...
- Sunday 1st January 2023 7:40pm
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
Re: What is the easiest way to get years, months and days?
Happy New Year BruceS My idea is similar to your logic. (It is not Work) Dim sFechaCompra As String = "21/12/2022" Dim sFechaEstado As String = "31/10/2024" Dim iYear As Integer = Int(DateDiff(Val(sFechaCompra), Val(sFechaEstado), gb.Month) \ 12) Dim dFecha As Date = DateAdd(Val(...
- Sunday 1st January 2023 4:47pm
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
Re: What is the easiest way to get years, months and days?
Hi cogier
Your code is failing with these dates:
DD/MM/YYYY
10/12/2022
29/12/2022
So far this is what I have verified. Greeting.
Your code is failing with these dates:
DD/MM/YYYY
10/12/2022
29/12/2022
So far this is what I have verified. Greeting.
- Sunday 1st January 2023 4:34pm
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
Re: What is the easiest way to get years, months and days?
Hi cogier. I hope you are feeling very well today. Look, I take my hat off to you. Thank you. I'm thinking of another solution but first I have to create it since it's only in my head. Thank you for everything, and I'm sorry in some way, that I have you very busy with my problem on the date that I h...
- Saturday 31st December 2022 6:34am
- Forum: Beginners
- Topic: What is the easiest way to get years, months and days?
- Replies: 12
- Views: 398
What is the easiest way to get years, months and days?
Happy New Year I was wondering, What is the easiest way to get years, months and days? Let me explain, I have two specific dates: "Purchase date" and "Date of return due to breakdown" and I want to present the user, for example: Purchase date: DD/MM/YYYY 21/12/2022 Fault Date: DD...
- Wednesday 28th December 2022 12:32pm
- Forum: Beginners
- Topic: What does "Dialog Management" mean?
- Replies: 4
- Views: 150
Re: What does "Dialog Management" mean?
Thank you BruceS
It's interesting information.

It's interesting information.
- Sunday 25th December 2022 3:49pm
- Forum: Beginners
- Topic: What does "Dialog Management" mean?
- Replies: 4
- Views: 150
Re: What does "Dialog Management" mean?
Aaah thank you 
