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!!
Views
Replies
Total Likes
Hi,
Here is a link that might help you. http://eslifeline.wordpress.com/2008/09/26/date-manipulation/
Thanks,
Bibhu.
Views
Replies
Total Likes
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>
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.
Views
Replies
Total Likes