cancel
Showing results for 
Search instead for 
Did you mean: 

Parameter date to select MM & YYYY??

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)