Re: [mapguide-users] Re: Date arithmetic

2012-03-28 Thread Ryan Northcott
Can't you use a date add function to get your results with two dates passed? - sent via mobile iOS5 On 2012-03-27, at 11:37 PM, elbison jacob.magg...@gmail.com wrote: I'd also like to know more about this. The MonthsBetween function only returns the number of month boundaries crossed.

[mapguide-users] Re: Date arithmetic

2012-03-28 Thread Hans Milling
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

[mapguide-users] Re: Date arithmetic

2012-03-27 Thread elbison
I'd also like to know more about this. The MonthsBetween function only returns the number of month boundaries crossed. I want dayspossible? -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Date-arithmetic-tp4197414p4663018.html Sent from the MapGuide Users mailing list