Property for hide the "30-12-1899" dates

eduardosic · Post by **eduardosic** » Mon 23 Apr 2007 20:52

Hi Antaeus, the TMyQuery Object has the property NullforZeroDate that shows NULL for Dates with value Zero. You can create a NULLFor30121899Date property? what functions in the same way? hiding the "30-12-1899" dates.

this property would be very good, with it does not to clean the fields it datetime.

Antaeus · Post by **Antaeus** » Tue 24 Apr 2007 07:26

We will investigate the possibility to add such option,
but due to low number of users' requests, it is unlikely that we will add it in
the nearest time.

eduardosic · Post by **eduardosic** » Tue 24 Apr 2007 12:54

Antaeus wrote:We will investigate the possibility to add such option,
but due to low number of users' requests, it is unlikely that we will add it in
the nearest time.

Hi Antaeus, thank for information, but this option is so simple that you it makes with the closed eyes and the hands moored without counting that this still leaves mydac more complete.

Thank you, mydac is a very good.

Antaeus · Post by **Antaeus** » Wed 25 Apr 2007 11:11

Yes, this option is simple to implement, but it makes MyDAC interface less intuitive. We will wait for other users' requests to take this decision.

eduardosic · Post by **eduardosic** » Sun 31 May 2009 23:26

Hi DevArt...

Zeos DBO show a Null value for a Date if = 30/12/1899, date = 0

you can implement a simple feature in MyDAC??

see the picture.

Dimon · Post by **Dimon** » Tue 02 Jun 2009 07:05

Please describe in what case do you need in this functionality?
The point is that the 30/12/1899 date is the correct date. If in your tables this date is equal to NULL value, you can just update tables and change 30/12/1899 to NULL.

eduardosic · Post by **eduardosic** » Tue 02 Jun 2009 11:05

The Problem is that 30/12/1899 are a date = 0, the majority of the desenvolvedores uses the date = zero to mark that the field dates is empty, and in the hour to show appears date 30/12/1899.

The behavior to hide date 30/12/1899 is native in the Zeos, does not exist a property for activated or to disactivate and nobody complains, for the opposite, the people likes very

Edison Garcia · Post by **Edison Garcia** » Tue 02 Jun 2009 12:56

Hi Anteus
I am one more to ask for the same thing. I agree with Eduardo (and you appears to have the same opnion) that this implementation is not a dificult thing to be done.
Best regards
Edison Garcia

eduardosic · Post by **eduardosic** » Thu 04 Jun 2009 14:15

Devart? please, implement this behavior. you can create a property to Enable or Disable this..

Dimon · Post by **Dimon** » Fri 05 Jun 2009 09:44

We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.

eduardosic · Post by **eduardosic** » Mon 08 Jun 2009 01:12

Dimon wrote:We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.

Thank's Dimon, i'm waiting

Edison Garcia · Post by **Edison Garcia** » Thu 18 Jun 2009 19:38

Hi Dimon

Thank you - I think it will be very usefull

Best regards

Edison

eduardosic · Post by **eduardosic** » Fri 26 Jun 2009 13:08

Dimon wrote:We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.

Thank's for this new feature!

eduardosic · Post by **eduardosic** » Fri 26 Jun 2009 21:25

eduardosic wrote:
Dimon wrote:We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.
Thank's for this new feature!

Dimon, i think in use Unidac.. this feature will be included in Unidac?

Dimon · Post by **Dimon** » Tue 30 Jun 2009 07:43

Yes, it does.

Devart Forums

Property for hide the "30-12-1899" dates

Property for hide the "30-12-1899" dates

ok..