Convert Part Lead Time From Int to Decimal

Hi,

I am running a DMT to update our part lead time, but a majority of them have errored out. Anything with a decimal is throwing “expected type is int32”.

Is there any way to alter the data type of a variable like this?

image

Is your lead time really 81.66666666667 days??

Just convert that to 82 and all should be fine. I don’t think you’ll have any luck changing the system structure. Better off rounding the lead time days up to an integer.

5 Likes

Brent Ozar coincidentally posted this recently

6 Likes