21 posts in this topic
This is a request to streamline various Date and Time functions. (PS My ability to log a ticket appears to be limited by an uncooperative server).
Let met start by saying these functions all work. This is not an error report.
The documentation appears accurate.
My problem started here:
contains "$sDate Initial date in the format YYYY/MM/DD[ HH:MM:SS]"
This is in stark contrast to eg
"This function takes a date input in one of the following formats:
"yyyy/mm/dd[ hh:mm[:ss]]" or "yyyy/mm/dd[Thh:mm[:ss]]"
"yyyy-mm-dd[ hh:mm[:ss]]" or "yyyy-mm-dd[Thh:mm[:ss]]"
"yyyy.mm.dd[ hh:mm[:ss]]" or "yyyy.mm.dd[Thh:mm[:ss]]""
my own personal, do-anything option
I understand that DTP and DateTime is not exactly the same. That is not the issue.
My problem is with being able to create and TEST a valid date in at least 3 different formats, but not being able to use additional functions on such a valid date. Assume my format is yyyy-mm-dd based on the "yyyy-mm-dd[ hh:mm[:ss]]" or "yyyy-mm-dd[Thh:mm[:ss]]" _DateIsValid() function. I now have a valid function, but cannot readily use it with any of the internal DateTime functions.
Would it be possible to consider modifying the existing functions to work with the standard formats. Put simply, if a format is accepted by _DateIsValid(), all other DateTime formats should work with same date (format) directly.
Once I have an accepted date, I want to use all internal functions on it.
Thank you for your kind attention.