ISO 8601 date to seconds

[J. Landman Gay]

On 1/28/2015 8:12 PM, Brahmanathaswami wrote:
> I have to deal with a lot date/time based algorithms on CentoOS/Word
> Press (and other similar frameworks) where "the Date" is usually output
> liked this, with no timezone code
>
> 2000-02-17T22:13:21-05
>
> As anyone written a script to convert this to seconds? I need to compare
> such a date with the time right now in LiveCode(server) and the only way
> is via seconds.

This should work:

function convertDate pDate
   put char 1 to offset("T",pDate)-1 of pDate into tDate
   put char offset("T",pDate)+1 to -4 of pDate into tTime
   put char -3 to -1 of pDate into tHrOffset
   replace "-" with slash in tDate
   set the itemdel to slash
   put item 2 to 3 of tDate & slash & item 1 of tDate into tDate
   set the itemdel to comma
   convert (tDate && tTime) to dateitems
   add tHrOffset to item 4 of it
   convert it to seconds
   return it
end convertDate

If the time zone includes minutes, you'd need to extract those and add 
them to the minutes item of the dateitems, just before or after the 
hrOffset is added.

-- 
Jacqueline Landman Gay         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com