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.)