- Joined
- May 5, 2015
- Messages
- 2
- Reaction score
- 0
hi guys,
can someone assist me on how to update the data based on dates.
i created table inventory return which consist item,start date , end date , rental term and status.Basically, the thing that i want to do is, the status column will changed into "YR1" when the start date has already complete its 1 year and "YR2" for 2 year while it will refer to the current date "date()". So, i try to use the query by "update into", but its not working.
Any idea for my problem?
can someone assist me on how to update the data based on dates.
i created table inventory return which consist item,start date , end date , rental term and status.Basically, the thing that i want to do is, the status column will changed into "YR1" when the start date has already complete its 1 year and "YR2" for 2 year while it will refer to the current date "date()". So, i try to use the query by "update into", but its not working.
Any idea for my problem?