Script to load 12 months data

[cjliew]

Dear all,

Any idea what is wrong with my script below?

It wouldn't filter and take in last 12 months data, it will load everything in.

Attached the sample data.

Below are my script:

Let vDate = Date(AddMonths(MonthStart(Today()), -12), 'M/D/YYYY');

LOAD
"Mandator (Code)",
"First Edit Date - Head",
"Main Sales Order No.",
"Order Value (Sales Value)"

FROM [lib://Finance/Open Sales Order/All OpenSalesOrder_Cognos11 (Also not open)/Current Year/Sample Data.xlsx]
(ooxml, embedded labels, table is page)
Where "First Edit Date - Head" > $(vDate);

[Vegar · Accepted solution]

Try this where statement :

Where "First Edit Date - Head" > '$(vDate)' 

[cjliew]

Thanks a lot, it did solved my problem:)