RowFilter Question

  • Thread starter Thread starter WStoreyII
  • Start date Start date
W

WStoreyII

i have a column that is transaction date the datatype is set to date for the
column

my question is i need to set a row filter that will show
all the dates that contain a certain year and month

i know that this would work to show just the certain date

like rowfilter = "tdate = '4/5/2006'" but how do i do so that only

i trieda wild card like 4/%%/2006 but that did nothing
so what should i do ?

WSToreyII
 
I don't think there exist date functions to use in a filter

what you could do is add a new column where you put the month as an integer
and use that column in your rowfilter


dominique
 
Back
Top