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 

 

I need this to show as 2 instead of the 1 day difference we usually use.

 

I am using:

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

 

How do I get the count to show 2??

 

2 Replies

  • AA622 

    try to add +1 in the end

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

    • AA622's avatar
      AA622
      Helper II

      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