Limit data using expression for dates

[K Clark]

I am trying to write a Limit Data Using Expression where InServiceDate >= 1/7/2014

The data type of this column is Date

I have other critera was well. I have this mess where I have gotten bogged down in the parantheses

CASE

WHEN ((([ARMApproved]!= "Yes") And ([Project Complete]!= "Yes"))

And ((([Overdue Project]= TRUE) And (([in Service Date] >= ("1/7/2014"))))))

then TRUE

ELSE FALSE

END

 

I tried getting rid of everything and just using this ( other combinations of ", ), etc) but I can't find what works.

CASE

WHEN Date([in Service Date]) >= Date("1/7/2017")

then TRUE

ELSE FALSE

END

Any suggestion would be appreciated.

[Kirsten Smith (she/her)]

Try changing:

 

WHEN Date([in Service Date]) >= Date("1/7/2017")

 

to

 

WHEN Date([in Service Date]) >= Date(2017, 01, 07)

 

You need to format the Date() function properly.

[Manmohan Agrawal]

Put [in Service Date]>Date(2018,5,2) in data limit. It will work

You need to format date in date(yyyy, mm, dd) format to put a certain date.

[Jane K]

Thanks for posting! This works.