Android Question lost in time

[67biscuits]

What am I missing in this equation?

Sub makeWD
    strD = $"${ms}/${ds}/${ys}"$
    DateTime.DateFormat = "MM/dd/YYYY"
    Log(strD)                            'output: 05/22/2025
    WD = DateTime.DateParse(strD)
    Log(DateTime.Date(WD))                'output: 12/30/2025
End Sub

Why or how does the date change from May 22 to Dec 30?

 

[JohnC]

Try "yyyy" instead of "YYYY"

 

[67biscuits]

so simple a solution..... argh... Thanks JohnC, That worked a charm

 

[mangojack]

Date Formatting - Difference between yyyy and YYYY

 

[67biscuits]

Date Formatting - Difference between yyyy and YYYY

thank goodness for standards. Now if we could standardize date formats globally. 06/06/2006 June 6th? 6 July??

 

[mangojack]

thank goodness for standards. Now if we could standardize date formats globally. 06/06/2006 June 6th? 6 July??

Day 's / Month 's / Year

And while we are at it .... Miles , Gallons , Pounds and Ounces , Feet and Inches etc.

I thought US was the only country to still use Imperial system , apparently so do Liberia and Myanmar. there you go.

 

[67biscuits]

Day 's / Month 's / Year

And while we are at it .... Miles , Gallons , Pounds and Ounces , Feet and Inches etc.

I thought US was the only country to still use Imperial system , apparently so do Liberia and Myanmar. there you go.

I live in Canada, a metric country, I use the imperial system for almost everything. And here the date is Month/Day/Year. Some parts of amurika its Year/Month/Day