How to suppress a date prior to Dec. 31, 1899 1

[iwm]

The client does not want to see dates prior to Dec. 31, 1899.

I used the Format Editor to suppress the date prior to Dec. 31, 1899:

{Reference.beginDate}< 'Dec 31, 1899'

This formula works except when the date is April 01, 2011.

It suppress the date when the date is April 01, 2011. Why does it suppress April 01, 2011? This date is not prior to Dec. 31, 1899.

The data type of this field is STRING.

Your assistance troubleshooting this issue is tremendously appreciated.


Ingrid

 

[Turkbear]

Hi,
Why not exclude it not just supress it?

In your record seelction formula add:

{Reference.beginDate} > 'Dec 31, 1899'


BUT, using a string for a date can cause unexpected issues since its value will be interpreted using ASCII coding of the string.

Try converting it with the Date function and then use:

Date({Reference.beginDate}) > Date(1899,12,31)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[IanWaterman]

Please do not double post