Forum Discussion
Solved
Lead time format from text to numeric
Good morning, I am trying to find a way to convert lead time data from what is attached to a numeric value such as the line for 6 months to be displayed as 168 days. exported data is shown below...
You need to supply an algorithm for determining that conversion or use a look up table. For example, you want 6 months to be displayed as 168 days. But various six month periods can have 182-184 days (fewer if you don't count the weekends) so it is hard to make the conversion to 168 days. Both months and years have varying number of days.
You need to supply an algorithm for determining that conversion or use a look up table. For example, you want 6 months to be displayed as 168 days. But various six month periods can have 182-184 days (fewer if you don't count the weekends) so it is hard to make the conversion to 168 days. Both months and years have varying number of days.