View Single Post
and if you want to to interpret these OmniFocus dates (dateStamp strings giving a number of seconds since midnight at the start of 1 Jan 2001) without resorting to Applescript date functions, you can keep to SQL with expressions like:

Code:
select (strftime('%s','now') - strftime('%s','2001-01-01'));
for Now or Current Date,
or:

Code:
select name, datetime(dateDue + strftime('%s','2001-01-01'), 'unixepoch') from task where dateDue is not null;
to convert a date field like dateDue to a human-readable string.