using todays date in calculated row

[kobiashi]

Hi


How can i use todays date in the expression builder when creating a calculated row in a table

so i want to be able to deduct todays date from another row.

 

[isladogs]

Use the following: =Date()

 

[kobiashi]

Use the following: =Date()

thanks for the reply

i tried to use that in the formula but it didnt work

heres what i tried

LastDone - Date()

 

[The_Doc_Man]

You have your answer, but you should note that putting calculations in a table is just NOT a good idea. Do calculations in a query. Also, do you realize that every time you open the table, you recompute the row? If the goal was to compute an elapsed time from one event to another, your computed row is NOT static.

 

[isladogs]

Agree with the Doc.
Using calculated fields in tables is a bad idea
Do this in a query where it will work

 

[Mark_]

thanks for the reply

i tried to use that in the formula but it didnt work

heres what i tried

LastDone - Date()

This would normally give you a negative value if LastDone is a date PRIOR to today. The calculation would normally be

Date() - LastDone

to give the number of days since the [LastDone] Date/Time.

 

[June7]

so i want to be able to deduct todays date from another row.

That statement is rather confusing.

If you want each record to pull value from another record - HAS to be done in query with nested subquery. Review http://allenbrowne.com/subquery-01.html#AnotherRecord

 

[The_Doc_Man]

Good catch, June!