Hi
I have a field in my database which stores a persons date of birth, its field type is datetime. When the user is submitting data, this field is optional. If the user does not submit data, then the default date of 01/01/1753 is inserted.
My problem occurs when I want to export all the data in the table to a csv file. I fill my dataset as per normal, now for each row in the dataset I am checking if the date of birth column has the default date 01/01/1753. I do not want my users to see the above default date and I am instead trying to remove the data completely, but the column requires that I insert some sort of datetime.
Can anyone recommend a possible solution?
Mike55.
I have a field in my database which stores a persons date of birth, its field type is datetime. When the user is submitting data, this field is optional. If the user does not submit data, then the default date of 01/01/1753 is inserted.
My problem occurs when I want to export all the data in the table to a csv file. I fill my dataset as per normal, now for each row in the dataset I am checking if the date of birth column has the default date 01/01/1753. I do not want my users to see the above default date and I am instead trying to remove the data completely, but the column requires that I insert some sort of datetime.
Can anyone recommend a possible solution?
Mike55.