>Phew! That was fun > >I Tried... ><@assign name=�weeknbr� value=�<@format str=�44� >format="datetime:%m/%d/%Y" informat=�datetime:%W�>� scope=�local�> >Darn, would have been nice if this worked ;-)
It'd be great to have a cross-application suite of tools for doing these calculations. In the same way that %Y is a standard, a standard set of ways to calculate dates, days and equivalents. That way we wouldn't have to reinvent the wheel each time Filemaker (the app I have most experience with), though derided by some, has a good suite of calcs for dates - but at times it still requires mental gymnastics when doing DateToText and TextToDate and when calculating date differences Or maybe it's just me... One I struggled with (in Tango) was displaying event dates (in our Events Diary) showing the event duration, such as 27/10/2002 - 29/10/2002 (English notation). That's easy - but what if you prefer 27 - 29/10/2002 ? And then what happens if the event spans month (or year) boundaries like 27/10/2002 - 1/11/2002 ? You could sit and code for every eventuality, but it'd make for a pretty dense block of code. In some ways it's easier to calculate it in Filemaker, throw it into a field and display the field. But then you start thinking about migrating to MySQL and what would happen then... Nick Froome http://www.bolide.co.uk/events ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
