How do I use "Inception Date" and "Expiry Date" in a report formula

Mark Williams

22 February 2012 11:03

I need to use the "Inception Date" and "Expiry Date" fields in a report formula but cannot see how to do it. I have tried the following:

[Record.InceptionDate]

[InceptionDate]

[InceptionDate_Value]

[InceptionDate_DateValue]

[InceptionDate_Cover]

[InceptionDate_Result]

I am initially trying this with just the Inception date but would eventually like to incorporate it into an if statement.

"Record Inception Date" works when not in a formula.

Cheers.

Mark

0

Comments

4 comments

Colin Kippin 24 February 2012 17:15

Hi Mark,

At present Inception and Expiry Dates are not available in functions within Reports.

They can be selected as normal columns though.

Colin

0

Comment actions Permalink
Mark Williams 24 February 2012 17:29

Thanks Colin, should I raise this as a feature request or is it being looked at already?

Cheers.

Mark

0

Comment actions Permalink
Colin Kippin 27 February 2012 14:23

Hi Mark,

We are always keen to capture these suggestions - I think these could be useful in reports so please put on as a Feature Request for other sites to look at and vote.

Colin

0

Comment actions Permalink
Adam Bishop 29 August 2012 13:57
Hi Mark,

This is due to change in the next major release of SchemeServe, development has started. In addition to the current functions:
- Row.GetValue and Row.GetString (both return string)
- Row.GetDecimal and Row.GetNumber (both return decimal)
...there is a new one on the way:
- Row.GetDate
You will be able to use this as follows:
```
IF(Row.GetDate("Inception") < NOW, "In the past", "Future date")
```
....where "Inception" is the name of another column.

Best wishes,

Adam
0

Comment actions Permalink

Please sign in to leave a comment.