Forum Discussion
Lead time format from text to numeric
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.
Hi Dfarn ,
Just following-up to check if any of the provided solutions have addressed your needs. If yes, please consider marking the helpful replies as accepted solutions to assist others with similar queries. Or if any other method worked, please share it here to help the community.
If further assistance is needed, please reach out.
Thanks ronrsnfld , slorin for sharing your valuable insights.
Best Regards,
Vinay.