Hello all!

Hello Tim,

You have 2 different options to achieve this:

a.) JavaScript
b.) SQL

I would personally use a SQL Default value query, since SQL is more natural to me than JavaScript. You can build quite a complex SQL query and return the date accordingly based on your requirements. I would recommend using the DateAdd function to determine whether to set the default date to +/- 14 days.

I would recommend looking throughout Google.com to find date functions that will help you achieve this. You'll want to keep your eye on DateName, DateAdd, and possibly DateDiff.

If this is something you'd like professional assistance with, Data Springs can be of assistance via Premium Integration Services, you can learn more about this offered service at the link below:

www.datasprings.com/support/premium-support/premium-support-options

To build a SQL script like you've described, I'd expect this to involve 1-2 hours to implement and test.

Please let us know if you have any questions.

Thanks,

Ryan