Set analysis using Today function

[helen_pip]

Hello

I was wondering if someone could kindly cast an eye over my set analsyis statement as it currently returning Null values

My aim is to produce a sum of data for the current day.   My dataset contains data for the entire quarter

My Test field returns data in this format: DD/MM/YYYY (14/01/2013)

My Today() functions returns values in this format DD/MM/YYYY (14/01/2013)

=SUM( {1<Test={$(=Date(Today(), 'DD/MM/YYYY'))}>}QuarterlyBreaches_Breaches)

Kind Regards

Helen

[jonathandienst · Accepted solution]

Helen

try putting quotes around the date expression:

=SUM( {1<Test={"$(=Date(Today(), 'DD/MM/YYYY'))"}>}QuarterlyBreaches_Breaches)

HTH

Jonathan

[helen_pip]

Hello Jonathan

Thank you for your reply.  You beat me to it, I had just found out about the "" quotes online and it now works perfectly

I was just about to re-post, so thank you for your reply

I am back on track again now

Thanks

Helen