Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
First of all thank you for your support.
I´m trying to load data from a specific date onwards but I´m not able to do it, taking as example this script:
LOAD
Ref.,
Artículo,
Posting Date (How can I do it here to set a start date higher than for example 01.01.2017?)
"Unidades Ventas",
"Importe Ventas Bruto",
"Importe Dtos.",
"Importe Ventas Netas",
"Coste Ventas Mov. Valor",
"% Dtos.",
All the best.
LOAD
Ref.,
Artículo,
Posting Date ,//(How can I do it here to set a start date higher than for example 01.01.2017?)
"Unidades Ventas",
"Importe Ventas Bruto",
"Importe Dtos.",
"Importe Ventas Netas",
"Coste Ventas Mov. Valor",
"% Dtos."
where date(Posting Date,'MM/DD/YYYY') >='01/01/2017'
resident <yourfile/table>;
@Godtooro wrote:[...]LOAD
Ref.,
Artículo,Posting Date (How can I do it here to set a start date higher than for example 01.01.2017?)
"Unidades Ventas",
"Importe Ventas Bruto",
"Importe Dtos.",
"Importe Ventas Netas",
"Coste Ventas Mov. Valor",
"% Dtos.",
Where lies your trouble? Is it in the consept or in the details? I believe that @Godtooro is pointing us in the right direction. By examening the details I notice two possible troubles, the field name does not have a quotation marks arount like this "Posting Date" and dateformats can be trouble. I'll try to write an answer similar to the previous answer, but where I try to rule out the two issues.
LOAD
Ref.,
Artículo,
[Posting Date] ,// Is it on the format MM.DD.YYYY or DD.MM.YYYY or other? Adjust the WHERE clause accordingly
"Unidades Ventas",
"Importe Ventas Bruto",
"Importe Dtos.",
"Importe Ventas Netas",
"Coste Ventas Mov. Valor",
"% Dtos."
WHERE
date#([Posting Date],'DD.MM.YYYY') >= date#('2017-01-01', 'YYYY-MM-DD')
FROM
[Your source]
;