calculated date

[Anonymous]

Dear all,

I'm trying to calculate two dates starting from the selected date, but I'm making some mistakes.

I've a list box with the operation date

Choosing a date, I would display into a graph, the total operations for the selected date, the total operation for 7 days ago and two weeks ago, like this:

Nr.Operation for select.date         Nr.operat.                              Nr. operat.

30 november 2012                      23 nov 2012                         16 nov 2012

          100                                        110                                        90

I tried the following:

count({<Operation_DATE={$(=only((date(num(getfieldselections(Operation_DATE))-7))))}>} OperationID)

but it doesn't work, it doesn't recognize the calculated date

Help please

Thanks in advance

[CELAMBARASAN]

Try with this

count({<Operation_DATE={$(=Date(Max(Operation_DATE)-7)))}>} OperationID)

[MayilVahanan]

HI

Try like this

count({<Operation_DATE={$(=Date(Max(Operation_DATE)-7))}>} OperationID)

If format difference

count({<Operation_DATE={$(=Date(Max(Operation_DATE)-7,'DD-MMM-YYYY'))}>} OperationID)

Hope it helps

[Anonymous]

Unfortunatly it doesn't work.

It seems that it recognize the correct date, but I don't have data into the related column. As operation date, I selected 27/11/2012. The calculated date is correct, but no data are displayed

= count({<Operation_DATE={20/11/2012}>} Operation)

[MayilVahanan]

then what you need on this situation?

[Anonymous · Accepted solution]

Hi,

I found the problem:

count({<Operation_DATE={"$(=Date(Max(Operation_DATE)-7,'DD-MMM-YYYY'))"}>}

It's necessary to add the double commas as wrote above.

Thanks to everyone who spent time to help me !!