Forum Discussion
DateDiff with a BLANK value
My table is very simple, its about damages and complaints.
A complaint is entered in the system on 25-7-17 and is closed on 28-07-17 so that complaint took 4 working days to resolve.
If a complaint is entered on 25-7-17 and is closed on 01-08-17 it took 8 days but there is a weekend in it so it's actually 6 working days. In my other rapports i have a table 'Date' with a calendar function, i thought the formula should check in this table how many workingdays (column 'IsWorkday'=1) there are between Start and End.
But if you say there is a better way i'm all ears.
the Relationship between Damages and Complaints and 'Date' is obviously on the 'date', direction both ways.
RvdHeijden hi ok so at this point what is wrong with the current calculation, that it doesn't take the isworkday = 1 into consideration.
did you check the data type ie if isworkday isnt a text field you will need to change it to isworkday = "1"
its hard for me to understand what the problem is without having a look at your actual data.
post screen shots of the data, with the measure and whats its returns. show all the columns required otherwise its not going to be easy to resolve what is going on