I’m trying to add 3 months to a field which contains date value by running the below query:
SELECT [Date Created], DATE([Date Created], '+3 month') AS 'Date Created (+ X Months)'
FROM WARRANTY_PN_MISSING_COMPATIBILITY_TABLE
Something seems to be wrong in fact this is the final result:
enter image description here
Please, can you help me on fixing the query?
Thanks
Fixing the query
3