Datatable Editor DateFormat

gunseli

Hi,

I get an error when I use the date format as follows.

Unable to cast value to be DateTime

     .Field(new Field("Vessels.ETA")
                       .Validator(Validation.DateFormat("Y-m-d"))
                       .GetFormatter(Format.DateSqlToFormat("Y-m-d"))
                       .SetFormatter(Format.DateFormatToSql("Y-m-d"))
                       )

My sql date format is like this.

2020-03-10 00:00:00.000

Thanks..

rf1234

Looks like wrong syntax.

https://editor.datatables.net/manual/nodejs/formatters?1

allan

Also, make sure your model uses a string type for the field, rather than DateTime (since DateTime has no direct representation in JSON).

Allan