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

[Gysbert_Wassenaar]

The date format of $(=Today()) is probably not the same as the date format of DATEFINANCIAL. Make sure that DATEFINANCIAL is in fact a date field and not a string. And use the date() function if necessary to format the result of today() to the correct date format. For example $(=date(Today(),'DD/MM/YYYY')) if the date format of DATEFINANCIAL is DD/MM/YYYY