Bug? Date format forces date to jump to 2020

[Pedro Caldeira]

Hello All,
I have a program that uses datepickers, and a customer today reported errors in the date.

After a quick look, i discovered that if I get the actual system date with datetime.date(datetime.now), I get 12/31/2019, that is correct
if I change the format to DateTime.DateFormat="YYYY-MM-dd" because that's what I use in that system, due to compatibility with other DB, i get 31-12-2020.

Any Idea ??

Regards

 

[LucaMs]

Hello All,
I have a program that uses datepickers, and a customer today reported errors in the date.

After a quick look, i discovered that if I get the actual system date with datetime.date(datetime.now), I get 12/31/2019, that is correct
if I change the format to DateTime.DateFormat="YYYY-MM-dd" because that's what I use in that system, due to compatibility with other DB, i get 31-12-2020.

Any Idea ??

Regards

 

[Pedro Caldeira]

however, if I pick separately the day, month and year, even after the dateformat, I get the correct values

Dim DayToday As String = DateTime.GetDayOfMonth(DateTime.Now) ' I get 31
Dim MonthToday As String = DateTime.GetMonth(DateTime.Now) ' I get 12
Dim YearToday As String = DateTime.GetYear(DateTime.Now) ' I get 2019

if i get the whole date like before, I get 2020-12-31

 

[LucaMs]

I wrote my post to say: "You made a mistake somewhere else, since formatting works regularly.

 

[LucaMs]

I wrote my post to say: "You made a mistake somewhere else, since formatting works regularly.

although it would be more correct: "yyyy-MM-dd"

 

[Pedro Caldeira]

I wrote my post to say: "You made a mistake somewhere else, since formatting works regularly.

How come ?
in your example, it shows 2020-12-31 today is still 2019.
It should read 2019-12-31, no !?

 

[LucaMs]

How come ?
in your example, it shows 2020-12-31 today is still 2019.
It should read 2019-12-31, no !?

I am already projected in 2020 ?

I had only looked at the order of the parts of the date, which in your case were reversed.

i get 31-12-2020.

 

[Pedro Caldeira]

I am already projected in 2020 ?

I had only looked at the order of the parts of the date, which in your case were reversed.

Ok, Is it a bug then ?
It looks like it

 

[LucaMs]

 

[LucaMs]

Ok, Is it a bug then ?

although it would be more correct: "yyyy-MM-dd"

it's really the fault of using capital Y.

 

[Pedro Caldeira]

ok, thanks

 

[Erel]

Y = week year
y = year

Week year term is explained here: https://docs.oracle.com/javase/7/docs/api/java/util/GregorianCalendar.html#week_year
Obviously it is not what you are looking for.