Forum Discussion

Usman's avatar
Usman
Frequent Visitor
8 years ago
Solved

Timestamp for web data

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 origi...
Need Help
  • rocky09's avatar
    rocky09
    8 years ago

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

     

    DateTime.LocalNow()
rocky09's avatar
rocky09
Solution Sage
8 years ago

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

 

DateTime.LocalNow()
Usman's avatar
Usman
Frequent Visitor
8 years ago
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's avatar
    rocky09
    Solution Sage
    8 years ago

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