Date/Time defaulting to 01/01/00

I am running an application using Powerbuilder 4.0.  The user has to enter
a birth date. 
There is an edit mask on the field(00/00/00 00:00).  The field is a
DATETIME field in the database.
If there is not a birth date and the user types in 00/00/00 00:00, the
birth date defaults to 01/01/00. 
How can I get the birth date field to be EITHER 00/00/00 00:00 OR NULL and
stop it from defaulting to 01/01/00.

Any help in this matter will be greatly appreciated.


Thank You,

P.J. Borandi
pborandi@nb.net
0
ed
9/23/1997 2:03:56 PM
sybase.powerbuilder.datawindow 28057 articles. 5 followers. Follow

0 Replies
927 Views

Similar Articles

[PageSpeed] 3

Reply:

Similar Artilces:

NULL DATE IS NOT NULL BUT 01/01/00 00:00
The following works if I'm in design mode, but it doesn't in the release version. I got a column field with a mask as mm/dd/yy hh:mm, when the value is null, it shows 00/00/00 00:00 which is what I want, but when user wants to delete an existing date, let's say 06/05/02 12:00, instead of going back to 00/00/00 00:00 it goes to 01/01/00 00:00. I am using PB 8 Ent and W2K operating system, database is in SQL2000. If I look at the value in the database it got 01/01/00 instad of <NULL>. try check 'blank is null' @ datawindow field setting... & allow ed...

Strange empty mail dated 1970-01-01 01:00
Hello In my Thunderbird 2.0.0.23 sometimes appears empty mails dated 1970-01-01. I can only delete them by rebuilding folder index. I created new profile but problem stayed. Could someone help. Best regards Slawek Poland __________ Informacja programu ESET NOD32 Antivirus, wersja bazy sygnatur wirusow 4465 (20090928) __________ Wiadomosc zostala sprawdzona przez program ESET NOD32 Antivirus. http://www.eset.pl lub http://www.eset.com Slawek wrote: > Hello > In my Thunderbird 2.0.0.23 sometimes appears empty mails dated 1970-01-01. I > can only del...

Default Date 01/01/1900 ro current date
Is there a way to change the PB default date of 01/10/1900? Is it a built-in setup or is there a setting I can change to make it use the current date instead of 10/10/1900? Thanks for your help! No. I believe PB uses an "epoch" integer for internal date storage, and 01-jan-1900 is what 0 translates to. You're just going to have to initialize ate variables as needed. <Anna> wrote in message news:4238932b.391a.1681692777@sybase.com... > Is there a way to change the PB default date of 01/10/1900? > Is it a built-in setup or is there a setting I can change t...

display DB default (1900-01-01 00:00:00.000) datetime in gridview as blank
Hi there and thanks in advance for any answer. I have a db table where I store production task items. In that table I have a field which is a datetime. I'm currently displaying the production tasks on a gridview. My problem is that when the manager does not specify a the datetime when he first fills out the order form, on the gridview I get the infamous 1900-01-01 00:00:00.000 db default time, and thats just nice.  Is there a way to simply display blank?? Or is there a way to input blank or null to the db?? Adam How are you inserting the records into the database if nothing i...

Upgrade 03.01.00
Hi,Trying to upgrade my site on win 2003 server, but can't get it working. Have upgraded (overwritten the old files with the new ones on the webserver). Have also updated the web.config with machinekeys etc. When I got to:http://xxx.xxx.xxx.xxx/Install/Install.aspx?mode=InstallI get this message:- - -Upgrading DotNetNukeCurrent Assembly Version: 03.01.01Current Database Version: 03.01.00 Upgrade Status Report00:00:00.015 - Upgrading to Version: 3.1.1 --------------------------------------------------------------------------------Server Error in '/' Application.-----------------------------...

Bug with a datetime of '1753-01-01 00:00:00' ??
1> select @@version 2> go --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Adaptive Server Enterprise/12.5.3/EBF 12330 ESD#1/P/Sun_svr4/OS 5.8/ase1253/1900/32-bit/FBO/Tue Jan 25 07:02:08 2005 (1 row affected) For the life...

can not convert '01/01/1900 00:00:00' to a Timestamp
I would like to do this INSERT INTO ita_badgeage VALUES ( '01/01/1900 00:00:00') I have got this error "cannot convert 01/01/1900 00:00:00 to a Timestamp" i try this but I have got the same problem : set option PUBLIC.timestamp_format = 'DD/MM/YYYY HH:NN:ss'; thank for your help evincent@itlink.fr No you change the date_order, not the date_format. Date_format is for DISPLAY purposes only. set option date_order='MDY' If this is via ODBC you must issue this AFTER connecting: set temporary option date_order='MDY' -- ...

date is 01/01/1900
I'm updating a row in sql2k and its updating my date field to 01/01/1900 no matter what I specify. Am I doing this correctly: UPDATE Purchase SET DOP = 25/03/2003 WHERE Code = 'code02' I'm using query analyzer also, same thing, although row updated successfully is 1. > UPDATE Purchase SET DOP = 25/03/2003 WHERE Code = 'code02' try : UPDATE Purchase SET DOP = '25/03/2003' WHERE Code = 'code02' or in access UPDATE Purchase SET DOP = #25/03/2003# WHERE Code = 'code02' though I usually try to use non-ambiguos date formats e.g. UPDATE Purchase SET DOP = '25 Mar...

date is 01/01/1900
I am using PB12.1 and MS SQL Server 2008 R2 Express , and I am connect through SNC I have code like::- ls_date = "28/12/2010" format is dd/mm/yyyy date ldt_date ldt_date = date(ls_date) but it gives date=01/01/1900 it means null date and in control panel\reginal setting I change date format to dd/mm/yyyy but problem still, could any one help me thanks That says the input was not recognized as a valid format - null input would return null. It's a better practice to use PB's date literal format "yyyy-mm-dd" to avoid problems, as the control panel se...

date is 01/01/1900
I am using PB12.1 and MS SQL Server 2008 R2 Express , and I am connect through SNC I have code like::- ls_date = "28/12/2010" format is dd/mm/yyyy date ldt_date ldt_date = date(ls_date) but it gives date=01/01/1900 it means null date and in control panel\reginal setting I change date format to dd/mm/yyyy but problem still, could any one help me thanks I just answered this question in the general section. Please don't crosspost - answers are more useful if the discussion is all in one place. Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do ...

Set dateTime variable to 01/01/1900 00:00
Just a very simple question and I know most of you may be able to answer this. I want to set the value for a datetime variable to 01/01/1900 00:00 (the format of this is dd/MM/yyyy hh:mm). I try to do this using the following code: Dim strDate as String = "01/01/1900 00:00"Dim ciCultureInfo As New CultureInfo("en-GB") Dim dtDate as DateTime = Convert.ToDateTime(strDate, ciCultureInfo) I get the error: String was not recognized as valid date time. Can someone help me out on this?  Basically, I just need to set the value for the dtDate variable to 01/01/1900 00:0...

Date being forced to 01/01/2000
On a date/time field, when a back space (or when a zero is keyed in) is used to correct either the day and/or month part of the field, PB forces the date to 01/01/2000. I would like it to be set to zeros instead. The datatype is datetime, format - [shortdate][time] with an editmask mm/dd/yyyy hh:mm I have several of these fields and so what is the best way to do this? ( PB Ver 7.0.2 Build 8011) thanks, madhu ...

1900/01/01 date issue
Hi, I have two date fields(date1 and date2) on a dw, both with editmasks in yyyy/mm/dd format. When the user enters 0000/00/00 in the first date field (date1), debugger shows date1's value as 1900/01/01 - the default value for invalid dates as I understand. The application has processing in the itemchanged event of this dw to SetNull date2 if date1 = 1900/01/01 and if not, do some processing and display a new date in date2. Is there a standard work around to allow the user to enter 1900/01/01 in date1, check for invalid dates, and still allow normal processing (perform the ca...

Inserting a NULL value instead of 01/01/1900 12:00:00 a.m.
Hello, I'm trying to save data from my asp.net page but even when I'm adding the NULL value in my query is still saving the 01/01/1900 12:00:00 a.m. in my datetime field This is my code:   Dim sqlConn As SqlConnection Dim sqlCmd As SqlCommand Dim strConnection, resul, COP, USD As String strConnection = ConfigurationManager.ConnectionStrings("SIPConnectionString").ConnectionString sqlConn = New SqlConnection(strConnection) COP = Replace(TxtCOP.Text, ".", ",") USD = Replace(TxtUSD.Text, ".", ",") resul = "Insert into...

Web resources about - Date/Time defaulting to 01/01/00 - sybase.powerbuilder.datawindow

Size matters when it comes to defaulting
Which borrowers are most likely to fall behind on their mortgage payments?

How much Nova Scotians are defaulting on student loans
These are student loan default rates for Nova Scotia students at post-secondary schools across the province.

Defaulting On Venezuelans
... that the country should default on its sovereign debt, because the government’s commitment to paying its creditors effectively means it’s defaulting ...

Etc: LightSquared has been accused of defaulting on a $56 million payment owed to the British satellite ...
LightSquared has been accused of defaulting on a $56 million payment owed to the British satellite company Inmarsat under a spectrum-sharing ...

When Will California Redevelopment Agencies Start Defaulting?
Public officials are scrambling in the wake of the Supreme Court’s decision in California Redevelopment Agency vs. Matosantos to react to their ...

Why Ireland Is At Risk Of Defaulting On Its Debt
The government needs to unwind its position in bank debt to solve the crisis.

COF: "Strikingly high FICO customers" Defaulting
Analyst: When you look at the closed in loans that are clearly under performing at this stage, what is it about either the underwriting or the ...

Many More Students Are Defaulting Than Official Tallies Show - Government - The Chronicle of Higher Education ...
One in five government loans made to borrowers who began repayment in 1995 has gone into default. The numbers are worse for students from for-profit ...

Some Chinese Buyers Defaulting on Raw Material Cargos
Some Chinese Buyers Defaulting on Raw Material Cargos

Author defends defaulting on student loan debt
Author Lee Siegel discusses the likely outcome if students defaulted on college loans.

Resources last updated: 12/11/2015 2:53:33 PM