Order TAT / SLA tracking
Afternoon, I have a scenario that I'm having trouble finding the right method / formula to tackle. Key points:
I have orders that are taken 7 days a week.
The TAT for Order - > Ship shoul...
Forum Discussion
Andrew -
You first need to determine if it was received before or after 1pm. For that, you'll use the HOUR function against your Timestamp field, which will result in a number representing the hour in a 24hr clock.
Hour([Order Date])
Then, if it's before 1pm, you'll have to calculate the next weekday using the WeekdayAdd function.
WeekdayAdd(ToDate([Order Date]),1)
If it's after 1pm, you'll have to calculate 2 weekdays out using the same function.
WeekdayAdd(ToDate([Order Date]),2)
Altogether, the formula would look something like this:
IF(Hour([Order Date])>=13, WeekdayAdd(ToDate([Order Date]),1), WeekdayAdd(ToDate([Order Date]),2))
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
You first need to determine if it was received before or after 1pm. For that, you'll use the HOUR function against your Timestamp field, which will result in a number representing the hour in a 24hr clock.
Hour([Order Date])
Then, if it's before 1pm, you'll have to calculate the next weekday using the WeekdayAdd function.
WeekdayAdd(ToDate([Order Date]),1)
If it's after 1pm, you'll have to calculate 2 weekdays out using the same function.
WeekdayAdd(ToDate([Order Date]),2)
Altogether, the formula would look something like this:
IF(Hour([Order Date])>=13, WeekdayAdd(ToDate([Order Date]),1), WeekdayAdd(ToDate([Order Date]),2))
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
That worked perfectly. Thank you so much!!
------------------------------
Andrew Gaubatz
------------------------------
------------------------------
Andrew Gaubatz
------------------------------
