NaN/yyyy/NaN Date Display

Submitted by nsheriff on Mon, 10/21/2013 - 00:02

I have an issue with dates in all of my forms using the calendar pop-up. The Date Data Format is set to "dd-MMM-yy"; Display Date Format is set to US Date - 10/22/2006 (the desired display date format). However after saving the date whenever I reload the form it comes back as NaN/2013/NaN. Any idea what may be causing this?

Some additional information is that I am persisting to an Oracle database and it is stored as "dd-MMM-yy".

RE: NaN/yyyy/NaN Date Display

Can you check in the logs to see what the actual format of the Date is directly after the data is returned from the SQL Database, and check the actual value.
Generally WebMaker converts the date formats to the "Standard" date format (schema standard) when it returns the data from a SQL database.
It is likely converting the oracle data format you described to the "Standard" Date Format before returned.

The format error above is suggesting a different format for the data received than the "Data Format" defined?
The Date "Data Format" needs to match the format of the actual data returned from the Data Source.
The other thing to check is if the date is returned without a value. This may cause an issue depending on what is returned.

So, you may simply need to set the "Date Data Format" to "Standard Date".