Forum Discussion

giorgilomidze's avatar
giorgilomidze
Resolver I
8 years ago
Solved

First date from date column

I need to have total number of days after first operation. Thus I'm trying to use this formula  datediff(firstdate([datecolumn]),lastdate([datecolumn]),days) but its not working. am i doing somethin...
Need Help
  • giorgilomidze's avatar
    giorgilomidze
    8 years ago

    I Used date format and it resolved problem  (taking .date from date/time format)

    DATEDIFF(FIRSTDATE([Datecolumn].[Date]),LASTDATE([Datecolumn].[Date]),DAY)

theitguy's avatar
theitguy
Helper I
8 years ago

Have you tried DAY instead of days as well?

 

datediff(firstdate([datecolumn]),lastdate([datecolumn]),DAY)
giorgilomidze's avatar
giorgilomidze
Resolver I
8 years ago

It is "Datediff" Formula Option.