Calculated date field on an Intake Form

[BillHa]

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)

[BarryBu2]

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