How to make a specific textbox become current system date to all records

[namliam]

NO you do NOT need a field containing the current date.... did you see my second post?

 

[juniepiper27]

NO you do NOT need a field containing the current date.... did you see my second post?

Ah.. about NZ? ok I will try it..

 

[juniepiper27]

NO you do NOT need a field containing the current date.... did you see my second post?

sir,

NZ Command is Error.. I try like this... NZ([evlrecved], Date())-[evldteisued],[evlrecved]-[evldteisued] and it become error this is the error message.. "The expression you entered contains invalid Syntax, or you need to enclose your text data in qoutes."

 

[namliam]

You need to use the exact function I gave you and not make up new stuff around it

NZ([evlrecved], Date())-[evldteisued]

 

[juniepiper27]

You need to use the exact function I gave you and not make up new stuff around it

NZ([evlrecved], Date())-[evldteisued]

Sir,

Even I put the exact function expression code you given to me. it has also an error.. this is the new error if I put your given expression... "The expression Nz([evlreccved],Date())-[evlsteisued] cannot be used in a calculated column"

and Sir, the function of IIf(IsNull([evlrecved]),[ddat]-[evldteisued],[evlrecved]-[evldteisued]) is a if else statement.. if there's no received date.. the durationdays will count a days from the dateissued up to current date. but if there's a received date.. the duration days will count from the dateissued up to received date.. that's why I used the IIF function..

please give me correct possible code expression for calculated current date..

Thank you so much... you are very big help for my database...

 

[RainLover]

juniepiper27

Date() is the Current Date

Now() is the Current Date and Time

You get these when you want them. You do not store them.

Namliam knows what he is talking about so take notice of him.

 

[namliam]

Listen, I dont need you to tell me how IIF works, NZ works the same or better for this "problem"

Please see attached sample for your intrest, just to show you in a query and a form how it works.

This works, dont know what you are doing wrong, but its something.

 

[juniepiper27]

Listen, I dont need you to tell me how IIF works, NZ works the same or better for this "problem"

Please see attached sample for your intrest, just to show you in a query and a form how it works.

This works, dont know what you are doing wrong, but its something.[/QUOT

Ahahaa! I'm sorry Sir if I too much bothering you... anyway I get your point.. & I admit is my fault.. you want me to make a expression in query.. while I'm doing your given expression in Table field.. hehehhe! I'm sorry for that.. I get.. I will modify again from the beginning my database I will follow your given sample.. but sir please see the attached sample database I created...

Thank you so much.. & more power!!

 

[Uncle Gizmo]

I've quite enjoyed this thread!!!

 

[namliam]

I think it has been re-itterated over this thread a few times now, DONT STORE a system date in your table...
Calculations are to be done in queries or reports/forms

 

[namliam]

Also looking at your database, please do review:
http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=naming+convention

 

[juniepiper27]

Thank you so much sir... I am beginner programmer that want to become a great programmer like you guys.. thank for the help.. if I making a Database again for our company.. I will take advise from you first to make my database much better. thank you so much...

 

[juniepiper27]

Yes sir, I already delete the current date in table and also the duration days.. I make a calculation in queries as per your sample.. thank you so much.. sir... I hope this is not the last time you will help me.. if I have a problem again in my database work.. thank.. you...