Unbound text box date calculation

[Neobeowulf]

Team,

I'm trying to use an unbound text box to calculate how many days have passed since another date in a form field. All I want the unbound box to show is a number like 12. For example if today is Aug 7 and the date in the form field is Aug 6, my calculation should show 1.

I've tried =Date()-[Decor6 Sent Date] and some other variations but I just can't figure it out. I'm hoping it's just something simple.

 

[ypma]

Try this for days count difference

=DateDiff("d",[sentdate],[anotherdate])

 

[Neobeowulf]

Hmm...not working. It just pops up as #Name?

I tried =DateDiff("d",[Decor6 Sent Date],[Date()]) Also tried =Date(), Now(), Today(). I can't seem to get it to calculate todays date - the sent date.

Update. Okay I did =DateDiff("d",[Decor6 Sent Date],-Date()) but it just fires out the date converted as a number -88667

 

[vbaInet]

Don't enclose Date() in square brackets.

 

[Neobeowulf]

Got it. The - was messing everything up. Thanks everyone for the help! As always, ya'll are awesome.