I have a report field CalDate. I need an unbound report field that displays a date 30 days from the bound CalDate field.
Thanks in advance.
I have a report field CalDate. I need an unbound report field that displays a date 30 days from the bound CalDate field.
Thanks in advance.
You are apparently aware of the DateAdd function. What happens when you use it? Do calc in query or in textbox. If you encounter specific issue, post description and attempted expression. Actually, days is default unit when doing arithmetic with a date value. Could simply do: [CalDate] + 30
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Not real familiar with writing the DateAdd Function. How would I write the expression in a textbox?
http://www.techonthenet.com/access/f...te/dateadd.php
Behind an = sign.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
'Wrong number of arguments'
=DateAdd([LastCal]) + 30
Let's look at how to use the DateAdd function in MS Access:
DateAdd ("yyyy", 3, #22/11/2003#)
Result: '22/11/2006'
DateAdd ("q", 2, #22/11/2003#)
Result: '22/05/2004'
DateAdd ("m", 5, #22/11/2003#)
Result: '22/04/2004'
DateAdd ("n", 51, #22/11/2003 10:31:58 AM#)
Result: '22/11/2003 11:22:58 AM'
DateAdd("yyyy", -1, #22/11/2003#)
Result: '22/11/2002'
zburns,
You have to look at the syntax of DateAdd and then supply the parameters.
You have mixed up the two methods I described. The second method does not use DateAdd. Review post 2.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yeah, my screw-up. Thanks to all