I need to create a new date based on a user input date by adding a specific number of days. I am just unsure how to reference the field that has the user input date and then add the number of days to create a new date. I hope that makes sense.
I was actually able to make it work with this.. sort of. ☺
Num2Date( (Date2Num(FORM.Main.sfConventional.tblChecklist.PS1.DateField1.formattedValue, "MMM DD, YYYY") + 60), "MMM DD, YYYY")
The problem I am working on is that when a date is input that is in the past, the year defaults to 1900. So, I’m really close, just have to figure out what I’m missing.
Thank you so much for your help!!!
Affinity Lending, Correspondent Division
WJ Bradley Mortgage Capital, LLC
10855 S. Riverfront Parkway, Suite 400
South Jordan, UT 84095
Phone: (801) 784-4054 / Ext: 4054
E-Fax: (855) 493-2289
Please note that my fastest response is via email.
Voicemails are checked periodically throughout the day. To ensure client and customer satisfaction; client and customer emails and voicemails will be returned within 4 business hours or less.
My business hours are 8:30 AM to 5:30 PM MST, Monday through Friday.