In a straight table is it possible to do aging calculation based on date of each record

[vvira1316]

Hi,

I've a straight table in which I need to do calculation based on date field of each record and today's date to find aging. Will it be possible to achieve it?

Please find information below. the calculation is based on today's date - [Request Date] for each Document ID.

Thanks,

Vijay

[sunny_talwar · Accepted solution]

You should be able to do this

=Today() - [Request Date]

Have you already tried this?

[vvira1316]

Hi Sunny,

Thanks for the reply. That is working. I've another situation where I'm trying to construct URL based on a field that has URL information but it is not available in all records. I've included that table below. Any idea for that one will be helpful.

I need to construct link from web address for a record where URL info is present (href value from below table)

[Document ID] & Chr(60) & 'URL' & Chr(62) & SubField(MaxString([Web Address]),'"',2)

How to use a field value of a particular/current record within set analysis to create hyperlink usin...

[vvira1316]

if I use same calculation in Text color than I'm not getting the right count in the table.

I'm having following expression in Text Color of the calculated dimension

=If((Today()-[Request Date])>2,RGB(174,30,35))

but it causes incorrect record count.

Any guidance?

Thank you in advance.

I figured my error and got it working using expression instead of doing calculation as a dimension.

[sunny_talwar]

So what is still not working? Or is everything resolved?

[vvira1316]

Hi Sunny,

Everything is working. Thanks for checking.

Regards,

Vijay