The [Lead Time Calculation] field within our "Item" table

lykkenn

I have a calculated field in Microsoft Dynamics NAV that I need to display via a website for lead time for Parts in one of our databases.

This particular field is the [Lead Time Calculation] field within our "Item" database table. In Navision, this field displays as a number followed by either the letter D (for day(s)), the letter W (for week(s)), the letter M (for month(s)), the letter Q (for quarter(s)), the letter Y (for year(s)) or the letters WD (for work day(s)). For example, if the [Lead Time Calculation] value is 150D, this translates to be 150 days and if the [Lead Time Calculation] value is 150WD, this translates to be 150 work days.

The problem is that in our SQL database table, these values of D, W, M, Q, Y and WD all display as the character: . So 150D on the Microsoft Dynamics NAV side ends up being 150 on the SQL side and 150WD on the Microsoft Dynamics NAV side also ends up being 150 on the SQL side.

Can anyone help me figure out how to convert this character of back to its proper value of either D, W, M, Q, Y and WD within our SQL database?

Please let me know.

Thanks,
Nathan

vaprog

Do a search on the forum and you will find DateFormula type and MSSQL.