delete a record based on certain calendar date

[qvqfqlik]

How to drop a record   for a certain  calendar date. Please help

[arasantorule]

Hi,

You can just load the data excluding that particular date.

If your requirement is different, can you explain in detail.

Thanks.

[ajsjoshua]

Hi ,

In script or in set analysis you can achieve your requirement

share some sample.

Regards,

Joshua.

[muthukumar77]

Hi,

Can you share the sample app?

[anagharao]

Hi,

You could use script level clause:

LOAD DATE(Date,'DD/MM/YYYY') as [Date],

    Amount

FROM

.\DropDate.xlsx

(ooxml, embedded labels, table is Sheet1)

where DATE(Date,'DD/MM/YYYY') <> '01/01/2016';

Regards,

Anagha

[qvqfqlik]

Thanks all !. I already fixed it.

Whenever I post, it needs moderator approval - which stuckup my work

[oknotsen]

That moderator approval has to do with you spamming a lot in your first few posts, spamming other topics with redirects to your (other) topics and stuff like that.

Act normal and that moderator approval will go away.

Topic locked.