I have a table that lists dates. How would I query a second column that shows the Friday for the week each date falls in to?
Assume each week starts on Saturday and ends on Friday.
Assume Table Name: "tblListDates", FieldName: "DateList"
i.e. My table may have the following dates. (In reality there is 500K records spanning from 1998)
Date List New Column I would like (Shows Friday of every week date falls into.)
Notice how in the new column (Second Column) each date is a Friday. This represents the Friday of the week the date in the first column falls into (Assuming every week starts on Saturday and Ends on Friday.)
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.