When you are working with dates only, the dateItems will usually show the hour as 2 am, but sometimes as 1 am depending on daylight savings. To avoid any potential cross-overs, when working with dates alone, I tend to supply a default time of midday. The convert command will not mess this up by supplying it's own default and since it is in the middle of the day, I know the date will be correct.
Re-writing my suggested function allowing for this: function weekDay pDate put pDate && "12:00 pm" into tDate convert tDate to dateItems put the last item of tDate into tDayNum put line tDayNum of the system weekdayNames into tDayName return tDayName end weekDay I think you will find this completely reliable. As an aside on the convert command: I have issues with the way convert automatically applies the current time zone when converting seconds so that a specific number of seconds refers to a moment in time and not to a set date & time. This makes the seconds useless to me as a data storage & transfer device since the conversions will vary from machine to machine depending on time zones etc. I now store all time stamps in a 14 digit number YYYYMMDDHHMMSS. However once I have this data, date & time calculations can be done locally with the convert command only being used to produce temporary variables, not long-term data storage. Cheers, Sarah
Thanks for your reply. Converting the date to dateItems actually crossed my mind, but are you sure the convert function is 100% bug free ? AFAIR, last time I used it in a cgi script, there was a 60 min difference in some conversions (unfortunately I don't remember in which cases, but I remember that this bug lead to a few threads on this list) and finally choosed to make all date conversions with mySQL instead... Best, JB > > Does anyone know of a function to find out, for instance, which day of > > the > > week was sept. 18th 1918 or which day of week will be dec. 5th 2025 ? > > > > If you convert a date to dateItems, it becomes a comma-delimited list > of 7 items. The last one is a number indicating the day of the week. > Then you can use the system weekDayNames to find the day name that > matches that number. > > e.g. > put "12/5/2025" into tDate > convert tDate to dateItems > put the last item of tDate into tDayNum > put line tDayNum of the system weekdayNames into tDayName > > Cheers, > Sarah _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
