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 original query which is pulling data from a website? To add timestamp of when the query was refreshed.
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()

3 Replies

  • 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.