11-08-2016 11:43 AM - edited 11-08-2016 11:46 AM
I'm trying to use both INTCK and DATEPART function, but it gives me an error:
ERROR 22-322: Syntax error, expecting one of the following: a name, *.
This is my code:
CREATE TABLE Client_month AS
INTCK('month', today(), datepart(t1.client_datetime, DATE9.)) as MONTHS
FROM Customers t1
I'm trying to obtain a range in months between today() date and a date, that is in datetime format, therefore I'm trying to use datepart format date9 to get it in normal date format.
I can't figure it out. Could you please help?
Need further help from the community? Please ask a new question.