Restrict data to last date of each month

[MatheusC]

Hey,

I have a table that comes from the SQL Server database, I want to restrict the data in this table to bring the stock value on the last date of each month only. I want to do it directly in the SQL command.

Thanks

[BrunPierre]

Hi, perhaps something along these lines.

LOAD ...
Where DateField = MonthEnd(DateField);
[BI_estoquedia]:
SELECT ...
FROM "bi_sense".dbo."BI_estoquw";