Expanding the Date table

In our previous lessons, we discussed the importance of having a well formatted Date table. A Date table has already been created using the CALENDAR() function that takes in two arguments.

For our Date table, we have generated dates from the first order date to the latest order date. Some columns have already been created, but we are going to expand on this by creating new columns using date and text functions to work out which day of the week a particular day is.