INTCK + DATEPART

[pkonopnicki]

Hi guys,

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:

PROC SQL;
CREATE TABLE Client_month AS
SELECT DISTINCT

t1.ID,
INTCK('month', today(), datepart(t1.client_datetime, DATE9.)) as MONTHS
FROM Customers t1
QUIT;

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?

thanks!

[LinusH · Accepted solution]

Datepart doesn't use a format as an argument.

[pkonopnicki]

Danke schon

[PGStats]

Use

INTCK('dtmonth', t1.client_datetime, datetime()) as MONTHS,

or

INTCK("MONTH", datepart(client_datetime), today()) as MONTHS,