Sybase Philippines

paul · by **paul** on Sat May 24, 2008 6:12 am

hi to all PB programmers:

In datawindow, how can i filter all the data with a month of january and with the year 2001 (regardless of days specified) if the selected criteria for Month is January and for Year is 2001.Assuming the equivalent
value for January is 1.

the data that was retrieve in the datawindow are:

Date
02/04/2007
01/08/2001
02/05/2004
01/09/2001
01/12/2001

and the output that i want should be look like this:

Date
01/08/2001
01/09/2001
01/12/2001

tnx in advance..

crvinodraja · by **crvinodraja** on Mon May 26, 2008 7:28 am

Call an event with something like this:

String ls_filter

//supposing the column with the date is called "some_date"
//also assuming that some_date is of date or datetime type
ls_filter = "Year( some_date ) = 2001 AND Month( some_date ) = 1"

dw_test.SetFilter( ls_filter )
dw_test.Filter( )

Sybase Philippines

Datawindow (Filter)

Datawindow (Filter)

Who is online