Store a QVD with a Variable Name

[stuwannop]

Hi Everyone

I can't seem to quite figure this out. I load a list of opportuntities from Dynamics CRM and store them as a QVD on a regular basis. What I want to do now though is take a snapshot of these records every month and keep the QVD's, albeit with a different filename.

In my script I want to store the filename as the first day of every month (as I will schedule it to run in QMS on the 1st of every month) so the filenames will be created monthly with the format:

01/06/2013Pipeline.qvd

01/07/2013Pipeline.qvd

     etc. etc.

I'm assuming I create a variable but how do I use that as part of the filename? I've tried: Store Pipeline as 'vdate'&Pipeline.qvd but it doesn't like it.

Also if anyone has any other views on how I can accomplish this "point in time" reporting I'd be very greatful. I plan to create multiple QVD's as the amounts of the pipeline records change month to month. i.e. Opportunity record one might have a value of £50,000 on the 1st June and £60,000 on 1st July and I need to track that.

Thanks

Stu

[Clever_Anjos · Accepted solution]

You are having problem because you´re using a "/" as a filename part, which is not allowed by Windows.

Use a "-" and will work as you write

Store Pipeline as '$(vdate)'&Pipeline.qvd(qvd)

[stuwannop]

Thanks Anjos.

I've set my Variable as =date(today(),'dd-mm-yy')&'Pipeline' and it's coming out as '11-00-13Pipeline' - any idea why the month is registering a 0?

Thanks

Stu

[Clever_Anjos]

Yes, you should use 'MM', because 'mm' stands for minute

[stuwannop]

Ah yes of course - thanks again for your help.

Stu

[Clever_Anjos]

You´re welcome. Keep in contact