Forum Discussion
replace a null date with a date in the same record
Hey all - I don't if this is simple or not. I am trying to calculate days between the two dates in the same record. Some dates in the first column are null and DATEDIFF does not like this. I w...
Something like this?
Days = IF(ISBLANK([Date]),DATEDIFF([EndDate],[EndDate],DAY),DATEDIFF([Date],[EndDate],DAY))
Thank you - I have got to tinker with formula but will get back with this post next week.