1155
Perspective
(slrpnk.net)
Libre Office: the glass is Feb 1st
Also the civilized world.
Some countries use YYYY MM DD which is also sane.
YYYY-MM-DD is the only sane format.
%s is cool as well in my opinion.
I prefer writing it out as DD MM YYYY, but i like my computer to sort everything by YYYY MM DD.
YYYY-MM-DD is the ISO standard for that exact reason. It sorts chronologically without having to implement a custom comparator, regular string comparison is enough.
In JavaScript it would be February 2.
In JavaScript it would be "true" for some reason
I am almost sure 1/2 is indeed true
Edit: in javascript
1st of February.
The realist: This is piss.
It was once
Or would that just be pissimistic?
That’s 0.5 more than January 0th, 1900.
I have the opposite problem. Half the time no matter how much I change the formatting on the cells I can't get a table to sort by date. It insists on alphabetical instead, so you've got 1/12/2024 ahead of 1/13/2023.
The solution for that is using a sane format for dates.
When I worked in radio production, basically everything was formatted like YYYY-MM-DD. Which means stuff is really to find and properly in chronological order.
I still use the MM-DD format for my own file formatting, even though DD-MM is the Dutch standard.
YYYY-MM-DD is god’s perfect date notation as far as I’m concerned.
Yeah - I don't get to determine what date format 3rd party reports are generated in before I import into excel.
But excel has formatting options specifically designed to address this that it just ignores half the time.
This is because you've accidentally input the values as text somewhere along the line. First make sure your format is set to date in the range in question.
Make use of the DATEVALUE formula in blank column =DATEVALUE(your_range). This will output your range as a number. Note that your_range needs to be in your computers date format (I have mine set to YYYY.MM.DD, so that what I have to use, else it won't work. You might be American, so your dates would need to be MM/DD/YYYY) for DATEVALUE to recognise the text as a date string.
Then copy the output, paste as values only (alt, h, v, v), then copy that and paste it back into you range.
Make sure the format is set to date and you're laughing.
I have never run into this problem and wondered why. I realised it's because I instinctively put an equal sign whenever doing a fraction.
Pretty sure I've had excel do something like change 1/2 into March 6th....
Or a UPC into scientific notation...
I've been doing heavy Excel/data work for years and never have I ever wanted or needed anything in scientific notation.
Physicist: state is undecided
Realist: the glass is plastic
The more lines you add in a program, the more stuff can break which is what I assume happens with excel when it thinks something is a date.
Spreaking from experience, my code is in a metaphorical sense a building that is built to lean towards the wind, but when the wind stops, the entire thing collapses. I assume that's how excel's code base works too.
this post was submitted on 20 Aug 2024
1155 points (99.5% liked)
Lemmy Shitpost
26715 readers
3511 users here now
Welcome to Lemmy Shitpost. Here you can shitpost to your hearts content.
Anything and everything goes. Memes, Jokes, Vents and Banter. Though we still have to comply with lemmy.world instance rules. So behave!
Rules:
1. Be Respectful
Refrain from using harmful language pertaining to a protected characteristic: e.g. race, gender, sexuality, disability or religion.
Refrain from being argumentative when responding or commenting to posts/replies. Personal attacks are not welcome here.
...
2. No Illegal Content
Content that violates the law. Any post/comment found to be in breach of common law will be removed and given to the authorities if required.
That means:
-No promoting violence/threats against any individuals
-No CSA content or Revenge Porn
-No sharing private/personal information (Doxxing)
...
3. No Spam
Posting the same post, no matter the intent is against the rules.
-If you have posted content, please refrain from re-posting said content within this community.
-Do not spam posts with intent to harass, annoy, bully, advertise, scam or harm this community.
-No posting Scams/Advertisements/Phishing Links/IP Grabbers
-No Bots, Bots will be banned from the community.
...
4. No Porn/Explicit
Content
-Do not post explicit content. Lemmy.World is not the instance for NSFW content.
-Do not post Gore or Shock Content.
...
5. No Enciting Harassment,
Brigading, Doxxing or Witch Hunts
-Do not Brigade other Communities
-No calls to action against other communities/users within Lemmy or outside of Lemmy.
-No Witch Hunts against users/communities.
-No content that harasses members within or outside of the community.
...
6. NSFW should be behind NSFW tags.
-Content that is NSFW should be behind NSFW tags.
-Content that might be distressing should be kept behind NSFW tags.
...
If you see content that is a breach of the rules, please flag and report the comment and a moderator will take action where they can.
Also check out:
Partnered Communities:
1.Memes
10.LinuxMemes (Linux themed memes)
Reach out to
All communities included on the sidebar are to be made in compliance with the instance rules. Striker
founded 1 year ago
MODERATORS