Create days from an input date

[kasey_eaton]

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.

Thank you!!

[Bibhu_Bikash_Na]

Hi,

Here is a link that might help you. http://eslifeline.wordpress.com/2008/09/26/date-manipulation/

Thanks,

Bibhu.

[kasey_eaton]

I was actually able to make it work with this.. sort of. ☺

if(HasValue(FORM.Main.sfConventional.tblChecklist.PS1.DateField1))

then

Num2Date( (Date2Num(FORM.Main.sfConventional.tblChecklist.PS1.DateField1.formattedValue, "MMM DD, YYYY") + 60), "MMM DD, YYYY")

else

null

endif

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!!!

Sincerely,

Kasey Eaton

Loan Coordinator

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

kasey.eaton@wjbradley.com<mailto:kasey.eaton@wjbradley.com>

www.wjbradley.com

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.