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,