donboe — 2010-08-25T01:54:29-04:00 — #1
Ho do I refer to a particular day in a week? I'm working on a site where new products will be added every Friday! I need to refer to that day so I can output only the records that where added that Friday?
Thank you in advance
system — 2010-08-25T15:33:44-04:00 — #2
In CF, DayOfWeek(dateValue) returns the day of week number (ie 1 through 7). Most db's have similar function(s), such as MS SQL has the functions: Weekday(dateCol) and DatePart(dw, dateCol).
The number representing "Friday" depends on which technique you use and your db settings** (ie some date functions are non-deterministic! So code accordingly).