Forum Discussion
add year month and week using just date field
I have this posting date field and I want to update yr mo and week based on posting date. I saw some suggestions online but cant make them work?
You should not store this type of data because it is derived data. By storing both the date and the day, month and year you run the risk of inconsistent data.
Store only the date. If you want to show the day, month or year you create a query. Use the DAY, MONTH and YEAR functions to derive the data.