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 something wrong?

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)

3 Replies

  • 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

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

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