By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,578 Members | 828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,578 IT Pros & Developers. It's quick & easy.

Expired date problem

P: n/a
In a database I have a table that amongst other cells has a "current date"
cell, and "expired date" cell and an "Index Number" cell.

The "index number" cell contains code that converts the "current date" cell
into an index number. (For example: 8/29/03 converts to an index number of
3241. The index number is done on the fly and is not written to the table.

As I needed the index number written to underlying table, there is "after
update" code in the "Current Date" cell that writes index number to the
table.

Now I have to fill the "expired date" cell. This date is 180 days after the
current date. My question is, can I have the "current date" cell do double
duty. Like another line of code somewhere in the "current date" properties,
that will fill the "expired date" cell with a date that is 180 days forward
of the current date.

Any help appreciated,

Thank you,

Bill.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
HJ
Where do you put this code? I suppose you use this on a form where the
record is being edited. Have a look at the DateAdd function to edit the
expired date.

HJ

"William Bradley" <br******@magma.ca> wrote in message
news:4Q********************@magma.ca...
In a database I have a table that amongst other cells has a "current date"
cell, and "expired date" cell and an "Index Number" cell.

The "index number" cell contains code that converts the "current date" cell into an index number. (For example: 8/29/03 converts to an index number of
3241. The index number is done on the fly and is not written to the table.

As I needed the index number written to underlying table, there is "after
update" code in the "Current Date" cell that writes index number to the
table.

Now I have to fill the "expired date" cell. This date is 180 days after the current date. My question is, can I have the "current date" cell do double
duty. Like another line of code somewhere in the "current date" properties, that will fill the "expired date" cell with a date that is 180 days forward of the current date.

Any help appreciated,

Thank you,

Bill.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.