Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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