updated views to use ansi sql 'extract' function to get month, date