Parameter date to select MM & YYYY??
I have 2 fields Year:YYYY and Month:MM in my database, however I can only get the date as a parameter (using a delivery system for email out the reports). I have the reports set to be sent at midnight on the last day of every month, and want to sort my report by current MM and YYYY from the parameter date u2013 but I am at a loss how to do this.
Month must be 2 digits, and year 4 digits.
Date parameter is currently in UK date format u2013 DD/MM/YYYY
I almost have it, I have 2 formula fields trimMM & trimYYYY and a parameter CurrentDate.
But these are outputting:- 9.00 and 2,008.00
I need them to be 09 & 2008
Edited by: Jonathan Muir on Sep 5, 2008 9:35 AM
And you can also right click those fields and click Format Field option then there you can change the format also for removing .00
Edited by: Ramesh Parsa on Sep 5, 2008 11:04 AM