Thursday 8 August 2013

SSRS - Default Date Parameter and other formatting issues

First day of the month
=CDate(Format(DateSerial(Year(Now()), Month(Now()), 1),"dd/MM/yyyy"))

Today
=CDate(Format(now(),"dd/MM/yyyy"))

Format Currency ($ Dollar)
'$'#,0.00;('$'#,0.00)

No comments:

Post a Comment