Hi,
First time here. I have a query with dates and if functions. Not sure if this is possible but need some guidance to see if this is actually possible with so many conditions;
<tbody>
</tbody>
First time here. I have a query with dates and if functions. Not sure if this is possible but need some guidance to see if this is actually possible with so many conditions;
If the date in G is sooner than J than this field should be the difference of the 2 dates in days * D (D is a number) If the date in G is later than J this field should be blank If the date in G = J than this field should be 5 * D If there is no date in J than take the date from N and follow these rules If the date in G is sooner than N than this field should be the difference of the 2 dates in days * D If the date in G is later than N this field should be blank If the date in G = N than this field should be 5 * D Thanks in advance! Caz. |
<tbody>
</tbody>