This brings back memories of trying to match locale info from my local computer, a remote server, a MySQL db, and a different Python app in a different server region.
It was for an international email campaign so each users email needed to match their in app locale for number and currency formatting, but there were like a half a dozen different layers of apps and servers that all handled locales differently.
Add in a hard deadline for the client and oof, that was a painful week.
LC_ALL=C is now cursed knowledge that resides in my brain. I wasn’t able to install Babel or any other libraries because security reasons so I had to handle everything manually.
Wouldn’t it be February first as the default in excel?
Edit: I tested this with excel. I typed “1/2” and it automatically converted it to “02-Jan”
Yes, 1 February It would have been for most. Now it’s just an north american joke
I just tested, entering “1/2” into excel results in “02-Jan”
Truly cursed.
I think it should follow regional settings, but don’t have high hopes (nor much the experience)
This brings back memories of trying to match locale info from my local computer, a remote server, a MySQL db, and a different Python app in a different server region.
It was for an international email campaign so each users email needed to match their in app locale for number and currency formatting, but there were like a half a dozen different layers of apps and servers that all handled locales differently.
Add in a hard deadline for the client and oof, that was a painful week.
LC_ALL=Cis now cursed knowledge that resides in my brain. I wasn’t able to install Babel or any other libraries because security reasons so I had to handle everything manually.Do =1/2 see what it gives
0.5 but keeps the fraction in the formula bar.
That one doesn’t surprise me at all.
Then go format as date on the cell
Jan 1, 1900
And as a time it’s exactly 12 PM
Weird. When I entered 0.5 as a raw figure it gave me Jan 0, 1900 at 12 pm.
1/2 = 0.5 Excel counts dates 1 from 01/01/1900. Entering 0.5 and formatting as date and time gives: 00/01/1900 12:00:00 because of course it does.
Of course is does. the Unix epoch isn’t “invented” by us so can’t go with that