Search the Community

Hi 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: page autoit.chm::/html/libfunctions/_DateAdd.htm contains "$sDate Initial date in the format YYYY/MM/DD[ HH:MM:SS]" This is in stark contrast to eg _DateIsValid "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]]"" or my own personal, do-anything option _GUICtrlDTP_SetFormat 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. Skysnake

SQLite has this: https://www.sqlite.org/lang_datefunc.html Compute the last day of the current month. SQL: SELECT date('now','start of month','+1 month','-1 day'); This is my take on the calculating the end of the month in AutoIt. I simply followed the logic of the SQLite. ; Compute end of current month Local $sNewDate = _DateAdd('m', 1, _NowCalcDate()) $sNewDate = _DateAdd('d', -1, $sNewDate) MsgBox($MB_SYSTEMMODAL, "5", "End of this month: " & $sNewDate) Is this the _only_ way? Best way?