What formula should I use to have a SSRS parameter show the first day of the current month as its default value in the format dd/MMM/yyy eg 01/Jan/2010?
I am currently using
=cdate(format("short date",DateAdd("d",(Day(now)*-1)+1,Now))) which returns it as 01/01/2010 17:11:16 I have also tried
=cdate(format("dd/MMM/yyyy",DateAdd("d",(Day(now)*-1)+1,Now))) with no better effect. I am also going to need a parameter for the last day of the month but its the formatting that is the problem at the moment.
I could easily get this with a call to the SQL Server but it seems a waste.