Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having the data which which comes out everything and i should name it according to the month wise
for example in the month of feb i will get jan data and it happens every month and i wanted to make qvd's for these monthly and store them
for this I am using
Let vPrevMonth =PICK((Month(Today())-1),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
store PastMonth into $(QVD)\vPrevMonth.qvd(qvd);
but it is not working
Try dollar expanding your vPrevMonth variable too:
store PastMonth into $(QVD)\$(vPrevMonth).qvd(qvd);
Try dollar expanding your vPrevMonth variable too:
store PastMonth into $(QVD)\$(vPrevMonth).qvd(qvd);
I am getting the month but also i need year also to be shown as Jan 2013
try
vYear = year(Today());
store PastMonth into $(QVD)\$(vPrevMonth&vYear).qvd(qvd);
by Rebeca
i want it to show Jan_2013.qvd
can you guide me on this one