Dear All,
I am using QV to create a load file for another reporting tool. This load file has a date fields (D_DP, D_PE) in a format rrrr.mm . In my accounting data loaded to QV I have as well month variable and it would be cool to make the data in D_DP & D_PE dependant upon the no of marked months in my MONTH field, as per the below:
No of marked fields data shown in D_DP & D_PE
2 2015.01
3 2015.02
4 2015.03
...
13 2015.12
I know I can not necesarely choose 2,3,4, subsequent months, however if there is no simple way to control it, then I would live with this potential risk.
Can you please help with proper formula for D_DP and D_PE fields? So fat it is just ='2015.10' and I change it manually at loads for sifferent set of months.
I attach a picture of part of my table and MONTH variable
thanks a lot in advance for your hints
