FavoritChristine Saxon fragte in #Data Management11. Mai 2012, 19:28Formula to calculate days since last review dateWe have an account review date field and want to calcuate , number of days since last review so regional managers can report on this. Only problem is sometimes a future date is listed as their indended date of review and we don't want to calculate based on future dates. How would we go about this?1 AntwortSortierenNach Datum sortierenNach "Am hilfreichsten" sortierenNach Datum sortierenSteve Molis (You Owe Me a Beer, Inc.)11. Mai 2012, 19:34IF(ReviewDate <= TODAY(), TODAY() - ReviewDate, NULL)Kommentar hinzufügenAntwort schreiben...FettKursivUnterstreichenDurchstreichenListe mit GliederungspunktenNummerierte ListeLink hinzufügenCodeblockBild einfügenDateien anhängenLink-URLAbbrechenSpeichern0/9000Antworten
Steve Molis (You Owe Me a Beer, Inc.)11. Mai 2012, 19:34IF(ReviewDate <= TODAY(), TODAY() - ReviewDate, NULL)