Hi Everybody,
I have included a calculated field in a table (using SDT). Then I use this calculated field in the Stonefield Reports.
The calculated field is
DATE_FLD1 - DATE_FLD2 and it works.
But when I included the MAX in the calculated field as
MAX((DATE_FLD1 - DATE_FLD2),0)
I get error message about missing ")" in a function name.
The error is generated by method ExecuteSqlSelect of class SfDataEngineVFP.
This seems like a problem with SFReports and not with the MAX()used in the calculated field expression. Does this seem like the correct assumption?
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham