Member Avatar for jared.geli
jared.geli 9 Junior Poster

I noticed that I can't use a field that has an expression ex:

Fields!date_due has an expression where if Fields!term.value = 7 it will add 7 days on based on the Fields!date_invoice. I want to get the days overdue based on the interval between Fields!date_due.value and Fields!date_collected.

Normally I would do this:
=DateDiff("d", Fields!date_collected.Value, Fields!date_due.Value)

But the result says "#Error" in the Fields!date_overdue.Value

I tried using the exact expression I used on Fields!date_due.Value but it only shows 0 andI'm not sure if it's correct so I want to use a variable to capture the value of Fields!date_due.Value or if you can provide me another option I'd be glad to.

  • 1 Contributor
  • 0 Replies
  • 72 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.