Entering a datetime into the Created Date and Modified Date fields requires pretty strict formatting, but still has some weirdnesses.
DateTime entries display in this format:
July 18, 2015 at 6:55 PM
You seem to be able to enter datetimes in these formats:
Month Day
Month Day Year
Month Day Year Time
Month Day Time
Time
Unentered pieces of data remain the same. Commas are irrelevant; you seem to be able to put one between the day and year if you want, or not. You can also put one between the month and the day with no ill effect. You can put "at" between the day and the time as you see fit.
If you enter something that it doesn't like, it just ignores the change and pops back to whatever was set before.
Time is a truly weird beast. Hours and minutes are separated by colons. If you try to also enter seconds, your entry is ignored. You are required to enter "AM" or "PM" (upper or lower case, or even mixed), but the hours field can range from 0 to 24. If you enter "PM", that apparently means "add 12 hours", because if you enter "16:00pm", it shows the new time as 4am. You can also enter "24:59am", which means 12:59am. If you include a date with your crazy rollover time, it also increases the date to the next day. So "January 1 2015 23:30pm" is accepted and shows "January 2, 2015 at 11:30 AM".
Personally, I want to be able to enter "2015-07-18 18:55:32" (or something similar that alpha-sorts and date-sorts the same way) and have it interpret that as "July 18, 2015 at 6:55pm".
Idea
wfaulk 0
Entering a datetime into the Created Date and Modified Date fields requires pretty strict formatting, but still has some weirdnesses.
DateTime entries display in this format:
You seem to be able to enter datetimes in these formats:
Unentered pieces of data remain the same. Commas are irrelevant; you seem to be able to put one between the day and year if you want, or not. You can also put one between the month and the day with no ill effect. You can put "at" between the day and the time as you see fit.
If you enter something that it doesn't like, it just ignores the change and pops back to whatever was set before.
Time is a truly weird beast. Hours and minutes are separated by colons. If you try to also enter seconds, your entry is ignored. You are required to enter "AM" or "PM" (upper or lower case, or even mixed), but the hours field can range from 0 to 24. If you enter "PM", that apparently means "add 12 hours", because if you enter "16:00pm", it shows the new time as 4am. You can also enter "24:59am", which means 12:59am. If you include a date with your crazy rollover time, it also increases the date to the next day. So "January 1 2015 23:30pm" is accepted and shows "January 2, 2015 at 11:30 AM".
Personally, I want to be able to enter "2015-07-18 18:55:32" (or something similar that alpha-sorts and date-sorts the same way) and have it interpret that as "July 18, 2015 at 6:55pm".
Link to comment
3 replies to this idea
Recommended Posts
Archived
This topic is now archived and is closed to further replies.