from my knowledge, you need to use the month day year function to break current date into its main components.
then, you reassemble it withe date(month(currentdate), day(currentdate) + x, year(currentdate))
Not essentially but exactly!
Get ( currentdate ) + 2 in a calculation that returns date will give you a date that is two days in the future.
In your case, I'd use datefield + 2 where "datefield" is the field where you are auto-entering the creation date.
This works because date fields are simply integer number fields that count the number of days since an early arbitrary date with special format options to display as dates. Thus, you can simply use them as number fields in calculation expressions.
Thanks Phil that worked perfectly! One last caveat, and this may be asking too much, but is there a way to get it to only evaluate weekdays? I can get the due date to be 3 days later, but if the date created is a Friday, for example, is it possible to get the due date to be Wednesday instead of Monday?
Yes, there's a dayofweek function that returns a number:1 = Sunday, 2 = Monday, .... 7 = Saturday.
There are a number of ways to do this and another forum member may have a better way, but the following works for me:
datefield + 2 + Case (dayofweek(datefield) = 5, 2, dayofweek(datefield) = 6, 2, 0 )
This assumes that no one enters data on a weekend date. If you need to allow for that possibility, you'll need to add more parameters to the case function.
Perfect! Thanks so much!