dateserial in report parameter

[lorca]

HI

i'm trying to setup a couple of report parameters for date start(1st day of currentmonth) and date end (last day of current month)

so i set the data type as string, and the default value for non-queried to (date start for example)

=format(DateSerial(Year(now), Month(now), 1),"dd/mm/yyyy")

but it returns 01/00/2006 ?

any ideas ?

thanks
ian

 

[Sheco]

Did you try using Today instead of Now?