I have a paid date comes from 1 query and invoice date comes from another query. Paid date is a details object variable and other is a Dimension objects. So i converted the Invoice date also to detail object variable. I want to calculate days between those 2 dates but the function gives Variable are not compatible (DMB0008) error message.
Both are date fields only and both are Detail objects and they also comes from multiple queries.
Is daysbetween function only works if both dates comes from single query. Is there alternative way to calculate days between if the date columns comes from multiple queries…
Thanks,
Raju
Rajua99 
(BOB member since 2004-12-16)