Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I HAVE 25 months data
it is like 2012-12 to till date, but i wanna to take 2013 jan .... by using addmonths function how can i do ?
hi,
I am not sure what you want to achieve, so can you explain your question?
If you want:
- to make data from 2012-12 to be acting as january 2013, then you can use addmonths
- change the format of the date, then you can use the date function
- filter the data, then you can add a where clause in the script (or a listbox in the frontend)
Kind regards,
Matthijs
Hi,
Please explain clearly with and example data for sort line.
1. Date is which format and it is date format or not.
2. You can use the Addmonths function for this then for loading data based on the where condition.
And you can try like
LOAD Date,
FROM Source.qvd(qvd)
Where Date >= AddMonths(Date( Today()-1), -12,'DD/MM/YYYY') And Date <= Date( Today()-1,'DD/MM/YYYY');
I you provide some date i let you know how to load the data.
Regards
Anand