Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert IIF To CASE
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Convert IIF To CASE
Miscellaneous
Thread ID:
01446575
Message ID:
01446575
Views:
103
I cannot get this Access IIF to convert right. Could use some help.

Here's the source
IIf([PK_RQ]![RQ_STATUS]="C" Or [PK_RQ]![RQ_QTY_ISS]>=[PK_RQ]![RQ_QTY_REQ],IIf([PK_RQ]![RQ_DATE_PROM]>=Date()-
365 Or [PK_RQ]![RQ_DATE_REQ]>=Date()-365,True,False),True)
Here's what I have
(CASE WHEN (RQ.RQ_STATUS = 'C' OR  RQ.RQ_QTY_ISS >= RQ.RQ_QTY_REQ) AND
(RQ.RQ_DATE_PROM >= DATEADD(dd,0,GETDATE())-365 OR RQ.RQ_DATE_REQ >= DATEADD(dd,0,GETDATE())-365) THEN 1 END = 1) AND
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform