Timestamp for web data

[Usman]

Hi, I have a query set up to pull data from a website, somehow I'm able to make a database of every time new data comes in, it stores in another query. My question is how we can add timestamp to original query which is pulling data from a website? To add timestamp of when the query was refreshed.

[rocky09 · Accepted solution]

go to query editor and then create custom column then input this in the formula bar

DateTime.LocalNow()

[Usman]

Thanks for the reply, will it change for previous data pulled from website when query is refreshed? Like Now() function do in Excel, it always shows the current date and time.

[rocky09]

It will show the date and time when the query was refreshed.