Help w/ set analysis

[#1]

Count({$<date(datetime_opened)>={date('2015-12-31')}>}case_number)

Hi, I only want to count the number of case_numbers that meet the datetime_opened>= 2015-12-31 criteria, but the set analysis is not working?

[sunny_talwar]

May be this:

Count({$<datetime_opened = {"$(='>=' & Date(MakeDate(2015, 12, 31), 'DateFieldFormatHere'))"}>} case_number)

Also, look here:

Dates in Set Analysis

[acardella]

Try this

Count({$< [datetime_opened] = {'>$(=Date(MakeDate(2015,12,31)))'} >} case_number)

Bye

[acardella]

sorry... i lost a =

Count({$< [datetime_opened] = {'>=$(=Date(MakeDate(2015,12,31)))'} >} case_number)

Bye

[sasiparupudi1]

Looks like your date time field is a timestamp..

In this instance, may be try

Count({$<datetime_opened={">='2015-12-31 00:00:00'"}>}case_number)

hth

Sas