Sum today() problems

[ecabanas]

Hi,

I'm trying to count the today orders , but it doesn't work!!!

=NUM(Count(DISTINCT{<[SALESID]={'PV0***'},DATEFINANCIAL={'>=$(=Today())'},ESTADO_PEDIDO={'Facturado'}>} SALESID),'#.###,')

Thank's

Eduard

[alexandros17 · Accepted solution]

The syntax is correct, I think the problem is linked to date format;

try to input an exact date instead of today and see if it works for example 25/03/2013 ....

Work on date format to solve the problem

Let me know

[ecabanas]

Hi Alex,

I still have a problem:

when I do this it works: =NUM(Count(DISTINCT{<[SALESID]={'PV0***'},CREATEDDATEID_={'41485'},CalendarMonthName=,CalendarYear=,ESTADO_PEDIDO=>} SALESID),'#.###,')

But if I Use the variable VToday that is a result of =floor(today())  equal: 41486 does not work

=NUM(Count(DISTINCT{<[SALESID]={'PV0***'},CREATEDDATETIME={'=$(VToday)'},CalendarMonthName=,CalendarYear=,ESTADO_PEDIDO=>} SALESID),'#.###,')

Thank you very much!!!

[alexandros17]

use Date(floor(today())

....