on 07-04-2014 10:37 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.