Help with the Error message

[Former Member]

Hi All,

When I am using the below logic in one of my pre defined condition created in UDT and using it in WebI I am getting the below error message

Database error: [Microsoft SQL Server Native Client 11.0]  failed when converting the varchar value '07/10/20' to data type int. (IES 10901) (WIS 10901)

Logic Used in UDT:

floor((cast(convert(varchar(8),(@Prompt('Enter Begin Start Date','D','Input Dates\Input Date',mono,free)),112) as int) - cast(convert(varchar(8),DW.DIM.DOB,112) as int) ) / 10000) >= 65 AND @Select(Input Dates\Input Date) between @Prompt('Enter Start Date','D','Input Dates\Input Date',mono,free) AND @Prompt('Enter End Input Date','D','Input Dates\Input Date',mono,free)

Database: Sql Server 2012

BO: 4.1

Any Ideas, Please

Thanks

[Former Member]

You're trying to cast a date as an integer. Why?