Calculated date field on an Intake Form | Community
Skip to main content
B
BillHa
Level 2
September 23, 2019
Question

Calculated date field on an Intake Form

  • September 23, 2019
  • 1 reply
  • 446 views
Hello, We would like to establish a calculated date field in one of our intake forms. On our Social intake form, we ask our users when they are looking to publish. We would like to establish a calculated field that looks at the requested date and compares to the current date; if the difference is 2 days or less, we would like to display text that say " this is an Urgent request; please contact ----- at extension ----". If the difference is 3-10 days, we would like "this is an Expedited request - please contact your Manager for permission." Any request more than 10 days would be treated as a normal request and would not display a message. Has anyone had any experience with this code? Sincerely, Bill William Harnett Federal National Mortgage Association (Fannie Mae)
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

B
BarryBu2
Level 8
September 24, 2019
Assuming the field where they tell when they are looking to publish is called Publish Date , the syntax would be: IF(DATEDIFF(Publish Date, $$TODAY)<=2,'this is an Urgent request; please contact ----- at extension ----', IF(DATEDIFF(Publish Date, $$TODAY)<=10,'this is an Expedited request - please contact your Manager for permission.')) However, calculated fields don't show up until they save (submit) the request. You might be better off giving them a 'Business Days' drop-down that has 1-10 (or 0 - 10 if you allow same day requests). You can then calculate the due date, and use display log to show: The urgent message if Business Days is 0,1 or 2 The expidited message if Business Days is 3 - 10 A date selection field if Business Days is > 10 Barry Buchanan - WMA Work Management Australia
Terms & ConditionsAccessibility statement

Loading footer...