Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I do not fix the dates it works. Any suggestion..LET vHoje = Date(Today(), 'YYYY-MM-DD');
LET vDateMin=num(makedate(2018,01,01));
LET vDateMax=floor(monthend(today()));
LET vDateMin2=num(makedate(2007,01,01));
LET vDateMax2=floor(monthend(today()));
Calenderio:
LOAD
Distinct
Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS CalendarDate,
ceil(Month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY'))/3) & 'Trim' as Trimestre,
month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Mes,
WeekDay(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Semana,
Day(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Dia,
year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Ano,
monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS MesAno
AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);
LOAD
Qtde_Estoque_Atual,
CodigoProduto,
if([Qtde_Estoque_Atual] <= 0,0,1) as Estoque_Sim,
NomeProdutoE,
Date(Floor(Data_Alteracao),'DD/MM/YYYY') as CalendarDate,
Data_Alteracao,
CodigoFilialE
FROM
[C:\Users\Gateway\Desktop\Estoque.qvd]
(qvd);