FormatDate and an Alerter applied on a column

building reports webintelligence
1

Hi

I have a column in a table of type date.
I have applied FormatDate([];“yyyy-MM-dd”) function on that column.
This column also has Alerter applied on it.
But Alerter does not works if we Format that column(FormatDate function).
When I remove this function,Alerter works.

Please suggest me appropriate solution.

Thanks
Amruta

megha_musale (BOB member since 2009-09-02)

2

Hi,

Try removing the alerter, apply the function and then add alerter.
It should work even if there’s an alerter on that column.

Thanks,
Srujana

srujanaj :india: (BOB member since 2010-02-10)

3

Is the alerter a comparison against a date field of some sort? A formatted date is really a string, which doesn’t compare the same way.

What if you just format the column (with cell formatting), without changing the values in it?

digpen :us: (BOB member since 2002-08-15)