OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: rstockton on March 09, 2015, 01:18:37 PM

Title: Entering a Blank Date in OnDemand Index "DATE" Field
Post by: rstockton on March 09, 2015, 01:18:37 PM
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
Title: Re: Entering a Blank Date in OnDemand Index "DATE" Field
Post by: Justin Derrick on March 09, 2015, 06:54:24 PM
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.
Title: Re: Entering a Blank Date in OnDemand Index "DATE" Field
Post by: rstockton on March 11, 2015, 07:30:01 PM
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.
Title: Re: Entering a Blank Date in OnDemand Index "DATE" Field
Post by: Justin Derrick on March 13, 2015, 11:47:11 AM
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.
Title: Re: Entering a Blank Date in OnDemand Index "DATE" Field
Post by: rstockton on March 13, 2015, 07:04:28 PM
I tested loading12/31/2058 in the index field and it was the latest date that I could use that worked.

Thanks,

Russell