Skip to Content
Former Member
Nov 07, 2011 at 07:45 AM

Extract MMM-YYYY and YTD from DD-MM-YYYY


Hi all,

I have a query with a Selection prompt for a field called Clearing Date in the DD-MM-YYYY format.

In the output of the query, I have Keyfigures that need to be restricted to the month entered in the clearing date and that needs to be displayed as MMM-YYYY.

Eg: When the query is executed, the user enters Clearing date as 02-02-2010

In the output of the query, I need to display Feb-2010 and the Key figures in the result need to be displayed for the month Feb-2010.

Is there a way of extracting the MMM-YYYY from the Clearing date entered into a new variable? If so, I can restrict the KF with the new variable created for MMM-YYYY.

Please let me know.

Thanks and Regards,

Srilakshmi B