Filter example 4: date functions

• Please note: when creating a filter some basic programming knowledge is essential. If you know which shipments you want to have filtered, but you miss the ability to write the correct filter statement, then send the programming desk a clear request by using your bug tracking system. Programmers will answer you back how much time is involved for creating this particulair filter.

• Please note: we use SQL -like date functions. If you are not familiar with these functions then please ask us to help by using your bug tracking system

• In the first rule a statement is created to display all transports from customer 1234.
• In the second rule a statement is created to display all transports where the deliveryDate is greater than today.
• NOTE1 : you can not use pickupDate or deliveryDate here because they are formatted like %d-%m-y. Use puDate (for pickupDate) and actionDate (for deliveryDate) instead. They are formatted like %Y-%m-%d.
• NOTE2 : you can also use today+1, today+3 etc. and even today-1 etc. for later or earlier dates.

Also see: TracktraceFilters

-- RutgerRutgers - 10 Apr 2007