Thread: [Announce] MaeCalTasks
View Single Post
jackburton is offline jackburton
2012-11-16 , 13:56
Posts: 466 | Thanked: 661 times | Joined on Jan 2009
#59
Here are some views I just created from the phone. Use this as an example.

Code:
INSERT INTO View (Summary,WhereClause,OrderBy)
VALUES
('Tasks Due Next 5 Days',
 'Type = ''2'' AND DateStart BETWEEN strftime(''%s'',''now'',''start of day'',''utc'') AND strftime(''%s'',''now'',''start of day'',''+4 day'',''utc'')',
 'status,DateStart'
);

INSERT INTO View (Summary,WhereClause,OrderBy)
VALUES
('Tasks Due Next 3 Days',
 'Type = ''2'' AND DateStart BETWEEN strftime(''%s'',''now'',''start of day'',''utc'') AND strftime(''%s'',''now'',''start of day'',''+2 day'',''utc'')',
 'status,DateStart'
);

maecaltasks_more_views by brander snaxe, on Flickr
 

The Following 6 Users Say Thank You to jackburton For This Useful Post: