TateLaing
5 years agoQrew Member
Change the Date in "Date Created" Field
Hello - I'd like to change the date in the "Date Created" field for a few records in a table. Is this possible?
The table automatically creates records on the last day of each month - formulas then reference the "Date Created" field to display "January" "February" etc. All reports for the table are filtered by month fields that reference the "Date Created."
The automated table has worked without flaw for about eight months, so I don't want to change the automation or have to use very specific IF statements in the formulas - however, I need to manually add records with months in the past. Since the month field displayed is indirectly tied to the "Date Created" field - I simply need to manually input the correct dates. Hopefully some of this context helps - even though the question is very simple.
Thanks,
------------------------------
TL
------------------------------
The table automatically creates records on the last day of each month - formulas then reference the "Date Created" field to display "January" "February" etc. All reports for the table are filtered by month fields that reference the "Date Created."
The automated table has worked without flaw for about eight months, so I don't want to change the automation or have to use very specific IF statements in the formulas - however, I need to manually add records with months in the past. Since the month field displayed is indirectly tied to the "Date Created" field - I simply need to manually input the correct dates. Hopefully some of this context helps - even though the question is very simple.
Thanks,
------------------------------
TL
------------------------------