# How to update the latest date in SQL table automatically after every build, which runs automatically

**URL:** https://www.finalbuilder.com/forums/t/how-to-update-the-latest-date-in-sql-table-automatically-after-every-build-which-runs-automatically/2048
**Category:** Discussion
**Created:** [November 19, 2012, 3:48am UTC](https://www.finalbuilder.com/forums/t/how-to-update-the-latest-date-in-sql-table-automatically-after-every-build-which-runs-automatically/2048 "2012-11-19T03:48:13Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [November 19, 2012, 3:48am UTC](https://www.finalbuilder.com/forums/t/how-to-update-the-latest-date-in-sql-table-automatically-after-every-build-which-runs-automatically/2048/1 "2012-11-19T03:48:13Z")

</div>

using Get Date Action I can store date in one variable, but I don’t get how to update in SQL script.

---

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [November 19, 2012, 4:48am UTC](https://www.finalbuilder.com/forums/t/how-to-update-the-latest-date-in-sql-table-automatically-after-every-build-which-runs-automatically/2048/2 "2012-11-19T04:48:15Z")

</div>

I mean, I already have SQl code but I don’t get how to call SQL Table form VBScript to write script in onGetDate() Action.

---

<div class="post-metadata">

### Author: ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)
#### Post date: [November 21, 2012, 7:10am UTC](https://www.finalbuilder.com/forums/t/how-to-update-the-latest-date-in-sql-table-automatically-after-every-build-which-runs-automatically/2048/3 "2012-11-21T07:10:32Z")

</div>

I’m not sure I understand what you are trying to achieve? Can you explain in more detail?

---

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [November 21, 2012, 3:45am UTC](https://www.finalbuilder.com/forums/t/how-to-update-the-latest-date-in-sql-table-automatically-after-every-build-which-runs-automatically/2048/4 "2012-11-21T03:45:12Z")

</div>

To update table automatically with the latest timestamp when ever final builder runs. Luckly I could solve this by writing VBS in “OnGetDate() script” for Get Date Action.