Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last Nine Quarters Data

Hi I want to extract out nine last nine quarters data only in the script. how i can achieve this ??

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

If you provide more information about your qvw file, you will get more accurate and specific help. Are you getting data from a database, text files, qvd files or some other source? Do you have a date field or only a month field. etc etc?

You can calculate the date for nine quarters ago using MonthStart(Today(), -9*3)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein