SQLite equivalent of SQL Server DateAdd function

Question

I need help reproducing the following SQL statement to a statement that SQLite understands.

SELECT * FROM SomeTable WHERE [Date] >= DATEADD(day, -14, GETDATE())

Any help is much appreciated!

Answer 1

From this link

Date And Time Functions

it would seem that you can use something like

date(timestring, modifier, modifier, ...) 

SELECT date('now','+14 day');

Does this seem correct to you?

Answer 2

link text