Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 14, 2023 07:11 AM - edited Feb 14, 2023 07:12 AM
I'm puzzled by an error I am coming up against ...
WORKDAY({Send your invoice by}, 10, '01-01-2023, 02-01-2023, 07-04-2023, 10-04-2023, 01-05-2023, 08-05-2023')
WORKDAY({Send your invoice by}, 10, '01-01-2023, 02-01-2023, 07-04-2023, 10-04-2023, 01-05-2023, 08-05-2023, 29-05-2023')
I don't understand why adding that date breaks the formula, can anyone advise please?
Solved! Go to Solution.
Feb 14, 2023 10:01 AM
Hi Hairtable. The WORKDAY function asks that your string of holiday dates are ISO formatted. AFAIK, that means YYYY-MM-DD. So, I'm not sure why your original date string is allowed, but I could imagine Airtable allows the MM-DD-YYYY format as well. Your original set can be mistaken for that format even though I'm sure you have it as DD-MM-YYYY. Then, you add 29-05-2023 and it breaks.
Feb 14, 2023 10:01 AM
Hi Hairtable. The WORKDAY function asks that your string of holiday dates are ISO formatted. AFAIK, that means YYYY-MM-DD. So, I'm not sure why your original date string is allowed, but I could imagine Airtable allows the MM-DD-YYYY format as well. Your original set can be mistaken for that format even though I'm sure you have it as DD-MM-YYYY. Then, you add 29-05-2023 and it breaks.
Feb 14, 2023 01:41 PM
That’s really helpful. Huge thanks @augmented
I have reformatted the dates as you suggest, and the error is gone 🙂