Remove Data by Date in script

[slribeiro]

Greetings, i'm new at this and would be amasing if you could help me.

I have one table like the following:

Name, Value, Date

A1, 3, 06-03-2015

A2, 2, 07-03-2015

A3, 6, 15-03-2015

A4, 4, 01-03-2015

How do i remove the data after 10-03-2015 in script?

I want to define a data in a variable and in this example have a final table like this:

Name, Value, Date

A1, 3, 06-03-2015

A2, 2, 07-03-2015

A4, 4, 01-03-2015

Best regards

Simão Ribeiro

[swuehl]

Set DateFormat = 'DD-MM-YYYY';

Let vDate = Num(MakeDate(2015,3,10));

LOAD Name, Value, Date

FROM YourDataSource

WHERE Date <= $(vDate);

[engishfaque · Accepted solution]

Dear Simao,

Kindly find attached document, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed