Skip to main content
Question

Change the Date in "Date Created" Field

  • June 25, 2020
  • 0 replies
  • 180 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You may not edit that field.  It is automatically populated and is in act part of an Audit trail which says reliably, when the record was created.

However, you can add two new fields

[Date Created Override]
[Date Created Created Final]

The formula for the latter would be

IF(not IsNull([Date Created Override]),[Date Created Override], [Date Created])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------