Null Date 31-12-1899

[Orit]

Hi All,

Can someone know what I need to do for get a real date when I'm using the date() function? I have a task list in a table (access 2007) and I don't know how to initiate that.

Thanks for any help

 

[boblarson]

What exactly are you trying to do? Dates are either null or not. If Null then there is no value. If set to 0 then it is set to the value of December 30, 1899.

 

[Brianwarnock]

Is this related to your previous thread?

Brian

 

[gemma-the-husky]

since a date of zero is 30/12/1899 - it follows that a date of 1 is 31/12/1899 - so is the "date" column showing 1 as a value?

 

[Orit]

Is this related to your previous thread?

Brian

Yes I hope that ok that I out another thread becouse it's another problem

 

[Orit]

since a date of zero is 30/12/1899 - it follows that a date of 1 is 31/12/1899 - so is the "date" column showing 1 as a value?

When I put the format as a general number - I get 1.

 

[boblarson]

What is the DEFAULT property in the table for the field?

 

[Orit]

What exactly are you trying to do? Dates are either null or not. If Null then there is no value. If set to 0 then it is set to the value of December 30, 1899.

I'm trying to update date field in the current date when other field got some text value

 

[Orit]

What is the DEFAULT property in the table for the field?

I didn't put defulte value becouse when I do it's automaticlly get the date and I want that it will stay empty until someone enter data in the another field.

What I have now is: Form - evetnt: before update: me.[A]= date()
In B field control source - A

Where A is the text field that will get data form the users and B automaticlly get date

Thanks a lot!

 

[boblarson]

Perhaps if you post a copy of your database we can better understand what you are doing. I am having a hard time picturing what you are actually doing.

 

[Brianwarnock]

That's not correct, as I explained in the other thread the code in the A field event, it was afterupdate last time, is me.B=date() and both control source are empty.

Brian

 

[Brianwarnock]

Bob have you read his other thread?

Brian

 

[boblarson]

Bob have you read his other thread?

Brian

Some -

I think we should see if Wazz or David can merge the two.

 

[Orit]

That's not correct, as I explained in the other thread the code in the A field event, it was afterupdate last time, is me.B=date() and both control source are empty.

Brian

Sorry, I tried this but it's not working

I can't upload the file with accdb suffix.

 

[boblarson]

I can't upload the file with accdb suffix.

Zip it... If you have WinZip or something else you can zip the file. If you have WinXP or Vista you can just right click on the file and select SEND TO > COMPRESSED FOLDER which is zipping it. Then, when it is zipped and has the .zip extension, you can upload it.

Also make sure to do COMPACT AND REPAIR before zipping. In 2007 that is under the round office button (soon to be the square office button in 2010) and then select MANAGE > COMPACT AND REPAIR.

 

[Orit]

Hi,

please see attahced. this is just an example

"Assign to"= A ( the field that get data from users
"Due Date" =B ( the automaticly date field)

thank guys!

 

[wazz]

I think we should see if Wazz or David can merge the two.

had a very quick look. i'm going to leave them as is. merging puts all the posts in chronological order. sorting it out would be quite painful.

 

[ByteMyzer]

Orit,

Trying to open the .ZIP file yields the following error:

Cannot open file: it does not appear to be a valid archive.

If you downloaded this file, try downloading the file again.

 

[Orit]

Hi,

Do you have access 2007 ? I'm able to open the file from the Zip. I'm trying to attached it again.

Let me know if it's ok now

 

[boblarson]

Hi,

Do you have access 2007 ? I'm able to open the file from the Zip. I'm trying to attached it again.

Let me know if it's ok now

This one appears to work. ( I have to wait until I get home to look as I don't have 2007 at work, but anyone else that has it is sure welcome to check it out and chime in).