PeterWindle

Dirty data in a date field

Discussion created by PeterWindle on Jul 3, 2013
Latest reply on Jul 4, 2013 by PeterWindle

Hello everyone!

 

I have a client who has a date field that sucks data in from a php web form.

Some of the data that gets put into the date field are simply not dates.

This date field is being used in a calcualtion and the "bad" data is mucking that up.

 

My question is simple, what's the simplest, quickest and most uniform way of testing for bad data in a date field? (non-date entries).

I've tried a number of techniques and nothing has worked well for me, any suggestions are most welcomed!!

Outcomes