Forum Discussion
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 ...
Anonymous
try to add +1 in the end
Duration.Days([pcreatedon]-[createdon]) +1
Anonymous
try to add +1 in the end
Duration.Days([pcreatedon]-[createdon]) +1
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