Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 05, 2008 at 09:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded