Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Date filtering(Date filtering)

Show: Today's Messages :: Show Polls :: Message Navigator

Date filtering [message #1006107]

Tue, 29 January 2013 22:22

Lauren Campbell

Messages: 2
Registered: January 2013

Junior Member

Hello,

I am working to filter a database with BIRT. I would like to filter so that only items with today's month and year are outputted. For example, the label column has tons of labels. I only want to show the items with "ID-13-1". 13 stands for 2013 and 1 stands for January. In february, I want it to automatically only show "ID-13-2". To do this I was trying to do the match filter:

"ID-"
BirtDateTime.year(BirtDateTime.today())
"-"
BirtDateTime.month(BirtDateTime.today())

I thought that would work but it does not. It does work if I actually type in "ID-13-1" but I wanted it to automatically output by the current date. Does anyone know how to do this?

Report message to a moderator