If I understand your question right, do the following: 1. In your database create a view based on your table that has a new column "expiresindays" or whatever you want to name your column. Use a datediff or whatever function provided by your database server to calculate how many days until the lease expires. 2. Open Maestro and add a layer that uses this new view. In the point/line/area rules simply add a new rule and set it to something like: http://osgeo-org.1560.n6.nabble.com/file/n4664065/Rules.png
-- View this message in context: http://osgeo-org.1560.n6.nabble.com/Date-arithmetic-tp4197414p4664065.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
