Lead Time Calculation

In the ‘Item table’ there is a field ‘lead time calculation’ that is a varchar (32).The current output is a number with a character behind it… how can this field be converted into a human readable field when queried on the back end with SQL?

This might get you going in the right direction.


In NAV, it’s called a DateFormula if it helps in your searches.

Your amazing!

It looks like there are still some displaying in the wrong format. but this gives me a great start…

Thanks again!!!