Entering a Blank Date in OnDemand Index "DATE" Field

[rstockton]

Is there any way to enter a blank date in an index filed that is defined as DATE?  It appears that the "DATE" format always checks for a valid date and the load fails if the date is not formatted correctly.

Thanks,

Russell

[Justin Derrick]

This is a *bad* idea.  Without a date field, you may never find a document ever again. 

You can enter a default date value, or enter the current date by using the 't' parameter as the default date.

Otherwise, it I think you'll need to have a conversation with whomever is sending you bad data.

Good luck!

-JD.

[rstockton]

Thanks Justin.

We will be doing the default of 12/31/2058.

By the way this is not a segment date field, just a date field being used as a search field.

[Justin Derrick]

Just remember that the old format date field had limitations on the range of dates.  If you're not on v9, this may give you trouble.

[rstockton]

I tested loading12/31/2058 in the index field and it was the latest date that I could use that worked.

Thanks,

Russell