#DateForumTypeThreadPost
503 Mar 2008 @ 05:20 PSTUDAReplyDate rangeI got this from someone in the forum last month as I had the same question....INNER JOIN (Select calendar_date-day_of_week-6 as min_date, calendar_date-day_of_week as max_datefrom sys_calendar.cale...
410 Jan 2008 @ 04:06 PSTDatabaseReplyFinding the last full weekYes, not sure what my major malfunction was...but thank you very much.
307 Jan 2008 @ 07:39 PSTDatabaseReplyFinding the last full weekthat does give me the dates I need, but I am having trouble incorporating this into my query.How do I incorporate it into my query the way you wrote it? I'm not sure what I would join on.
207 Jan 2008 @ 04:14 PSTDatabaseTopicFinding the last full weekI am trying to get data from the previous week for a weekly report...for example on Monday the report would run for the previous week (Sunday - Saturday).I am currently usingwhere week (trans_dt) =...
102 Oct 2007 @ 01:23 PDTUDAReplyMinusing row valuesA. Is it possible to to do this if the col I want the difference of is a Date and to have it returned as the # of days rather than the numerical difference of the system date (1071001 - 1070901). I...