AppGini Community Forums

I have searched but did not really find anything to solve my problem.

I have a date field in a table, and I have a date field that is readonly (calculated field) with the following statement.
The date does not add....

An help appreciated….

Thanks!!

Hi

Try

SELECT ADDDATE(Election_Date, INTERVAL 18 MONTH)_Date from Elections

But you should add you PK identifier to get only the record you are looking for.

Somethink like:

SELECT ADDDATE(Election_Date, INTERVAL 18 MONTH)_Date from Elections where ID = ...

Perfect Perfect!!!

Thanks!!!