Custom Function for working with ISO timestamps
Anybody have a know of a custom function for working with ISO timestamp format.
ISO Format is yyyy-mm-ddThh:mm:ss.sssZ for example right now it is 2009-03-12T21:01:27.000Z
(the z is zulu or GMT)
March 3rd 2009, 4:01 PM Eastern.
I need to convert ISO time into a format filemaker can do math on. Currently the ISO time is stored in just a text field. I need to get it into a date field, or a timestamp field so I can add and subtract time to it. The kicker is ISO time is displayed in GMT so you have to account for the timezone differance. However the offset from GMT changes based on daylight savings time.
I wrote what I thaught was almost a perfect function for this (only bug was if you evaluated at 12:00:00.000 AM), and it worked fine until last Sunday when the clocks sprung forward. Now it doesent even come close to working. I have been messing with it for 5 days and can't get it right.
Any help would be appreciated.