giffordpinchot
Registered User.
- Local time
- Today, 05:34
- Joined
- Nov 22, 2005
- Messages
- 10
Hello everyone,
I use the following to export a table with a time stamp but it only gives me the current date. How would I change this to include the date the table was last updated? I see there is a lastupdated property but I can't seem to use it to write the filename.
any helpers? please and thanks!
giffordpinchot
I use the following to export a table with a time stamp but it only gives me the current date. How would I change this to include the date the table was last updated? I see there is a lastupdated property but I can't seem to use it to write the filename.
any helpers? please and thanks!
Code:
DoCmd.OutputTo acTable, "Treatments", "MS-DOSText(*.txt)", "C:\cfru_SRM\Databases\CTRN\Backups\Treatments_" & Format(Treatments.LastUpdated, "mm.dd.yy") & ".csv", False, "", 0giffordpinchot
