Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a raw data file , due to operator enter wrong year 2020 , now it affect my QV report. as i am not able to display all SOURCE compute by sales.
Does any one here know how to remove the particular data year = 2020 to 2010 ?
Paul
Hi Rud
it work , thank you .
Paul
Hi Paul,
Is your problem not to load dates which have 2020 or to replace it with another year
Hi Kumar
My issue operator data entry enter wrong date , the date affect my report , and i want to use script to change the year from 2020 to 2010.
Paul
Hi Kushal
Do you mean i can do some thing like below :-
Binary "C:\Users\QV\Dropbox\QV file to PY Dropbox\000_qvd_v11.qvw";
where year(DateField)<= year(today());
So those year more then current year will change to current year it is ?
Paul
Hi Rudolf
thank you very much for your script . I have tested it work fine. many thank.
Paul