Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Edited:-

I almost have it, I have 2 formula fields trimMM & trimYYYY and a parameter CurrentDate.

month ({?CurrentDate})

year ({?CurrentDate})

But these are outputting:- 9.00 and 2,008.00

I need them to be 09 & 2008

Any ideas?

Edited by: Jonathan Muir on Sep 5, 2008 9:35 AM

Former Member
Former Member replied

try

totext(year({?CurrentDate}),"00",0,"")

totext(month({?CurrentDate}),"00",0,"")

And you can also right click those fields and click Format Field option then there you can change the format also for removing .00

Regards,

Parsa.

Edited by: Ramesh Parsa on Sep 5, 2008 11:04 AM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question