Tags for date dimension
Determining Month-End Date for a Date Dimension
How do you determine the month-end date when building a date dimension? One of our ETL developers recently pointed out that our date dimension (which I had populated) had incorrect values for month-end date, so I had to find a way to reliably calculate that value.
date sql time dimension date dimension