cancel
Showing results for 
Search instead for 
Did you mean: 

Require a correction in formula

Former Member
0 Kudos

Hi,

"[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string "

This is error i am getting when i am executing the following Formula in IDT

MSEG.BUDAT between convert(varchar(8),DATEADD(month, DATEDIFF(month,-2,@Select(Mseg\User Date)) - 16,0),112) and convert(varchar(8),DATEADD(month, DATEDIFF(month, -0, @Select(Mseg\User Date)) - 4, 30),112)

This formulae is forfinding material for previous Month.

Accepted Solutions (1)

Accepted Solutions (1)

former_member4998
Active Contributor
0 Kudos

Hi


Try the below sample Code.

CASE

WHEN

Table. Field Name

BETWEEN  dateadd(MONTH,-1,@Prompt('Enter Value for Date From','D','Class Name\Field Name',Mono,Free,Persistent,,User:-1))

AND dateadd(MONTH,-1,@Prompt('Enter Value for Date To','D', 'Class Name\Field Name',Mono,Free,Persistent,,User:-1))

THEN 'Previous Month Period'

END

Field Name Date Type as Date

former_member4998
Active Contributor
0 Kudos

Hi

Is your problem had solve?

PLEASE mark blog as helpful & answered

Answers (0)