67biscuits Member May 28, 2025 #1 What am I missing in this equation? B4X: 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?
What am I missing in this equation? B4X: 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?
67biscuits Member May 28, 2025 #3 so simple a solution..... argh... Thanks JohnC, That worked a charm Upvote 0
mangojack Expert Licensed User Longtime User May 29, 2025 #4 Date Formatting - Difference between yyyy and YYYY Upvote 0
67biscuits Member May 29, 2025 #5 mangojack said: Date Formatting - Difference between yyyy and YYYY Click to expand... thank goodness for standards. Now if we could standardize date formats globally. 06/06/2006 June 6th? 6 July?? Upvote 0
mangojack said: Date Formatting - Difference between yyyy and YYYY Click to expand... thank goodness for standards. Now if we could standardize date formats globally. 06/06/2006 June 6th? 6 July??
mangojack Expert Licensed User Longtime User May 29, 2025 #6 67biscuits said: thank goodness for standards. Now if we could standardize date formats globally. 06/06/2006 June 6th? 6 July?? Click to expand... 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. Upvote 0
67biscuits said: thank goodness for standards. Now if we could standardize date formats globally. 06/06/2006 June 6th? 6 July?? Click to expand... 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 Member May 30, 2025 #7 mangojack said: 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. Click to expand... 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 Upvote 0
mangojack said: 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. Click to expand... 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