on 09-05-2008 8:25 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.