Search found 89 matches

by gambafeliz
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...
by gambafeliz
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?

:o :shock:
Ole !!!
For me you are a machine. Thank you for your masterful solution
by gambafeliz
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)
by gambafeliz
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...
by gambafeliz
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(...
by gambafeliz
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.
by gambafeliz
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...
by gambafeliz
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...
by gambafeliz
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

:shock:

It's interesting information.
by gambafeliz
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 :)