Forum Discussion

AA622's avatar
AA622
Helper II
2 years ago
Solved

Custom Column Duration.Days (include first day)

Hello   I am trying to create a custom column to show the difference in days between 2 dates.    I need to include the first date in the count Ex pcreatedon: 12/5/2023 createdon: 12/6/2023   ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    AA622 

    try to add +1 in the end

    Duration.Days([pcreatedon]-[createdon]) +1

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

AA622 

try to add +1 in the end

Duration.Days([pcreatedon]-[createdon]) +1

AA622's avatar
AA622
Helper II
2 years ago

This seems to work. I want grab the days and filter out weekend and holidays. I have a calendar table where I have a column indicating if a weekday is a weekend/holiday. Weekday = 1 else =0.

How would I go about this