Calculating the Difference Between 2 Dates

Hi There,

I need your help.

I can't seem to wrap my head around this:

I have the following code:

today = Format(Date, "dd/mm/yyyy")

MsgBox DateDiff("d", today, "04/02/2011")

and it returns 31 when it should be returning a date difference of 1.

I need the date in the following format dd/mm/yyy

Any help with this is greatly appreciated.

Thanks.

Jay