Aggiungi ai preferitiImalka Jayalath (Experian) ha fatto una domanda in #Reports & Dashboards27 apr 2021, 07:11What is the best way to calculate the number of dates between a date column and today ?On a report I want to calculate number of dates between contacting client to today . What is the formula I can use ? Thanks !14 risposteOrdinaOrdina per dataOrdina in base alla maggiore utilitàOrdina per dataCarica più commenti...Risposta accettataAmnon Kruvi (The Architech Club)27 apr 2021, 18:17TODAY() is a Date field and LAST_UPDATE is a Date-Time field. Try either using NOW() instead of TODAY(), or only getting the date portion of last update: TODAY() - DATEVALUE(LAST_UPDATE)Aggiungi un commentoScrivi una risposta...GrassettoCorsivoSottolineaBarratoElenco puntatoElenco numeratoAggiungi linkBlocco codiceInserisci immagineAllega fileURL del linkAnnullaSalva0/9000Rispondi
Risposta accettataAmnon Kruvi (The Architech Club)27 apr 2021, 18:17TODAY() is a Date field and LAST_UPDATE is a Date-Time field. Try either using NOW() instead of TODAY(), or only getting the date portion of last update: TODAY() - DATEVALUE(LAST_UPDATE)
