ExampleFour < Cargooffice

Tags: view all tags

---++ 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 [[BugtrackingDocumentation][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 [[BugtrackingDocumentation][bug tracking system]]


<A HREF="%ATTACHURL%/filter06.gif"><img vspace="10" width="500" alt="" src="/pub/Cargooffice/ExampleFour/filter06.gif" title="det functions (click for enlargement)" border="0" /></A>

   * 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.


<br>
Also see: TracktraceFilters
<br>


<br /> <br /> -- Main.RutgerRutgers - 10 Apr 2007

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
gif	filter06.gif	r4 r3 r2 r1	manage	43.1 K	2019-01-22 - 11:20	HenkRoelofs

Topic revision: r2 - 2019-01-22 - HenkRoelofs