Forum Discussion

DNicoll's avatar
DNicoll
New Member
5 years ago

Get Data from Server within a dynamic date range

Hi,  I see there is a post - Dynamic Data fetch trigger while changing the date range, with a similar question. It is fairly old so I was wondering if there was any update. I have the same issue, I ...
Need Help
DNicoll's avatar
DNicoll
New Member
5 years ago

Hey Anonymous,

   Thank for your prompt reply. I now realise I did not supply full information. I have 2 data sources, one MS SQL, which has lower data levels so less of a problem. The other is an ODBC connection to a large real time database. In excel, it is easy, a query that takes the dates required and passes as parameter to ODBC SQL. I really don't want to be involved in what data they select, so pulling fixed data into a BI is really not what I want.

May be need to dig deeper.

 

      

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi DNicoll ,

     

    How do you define the required dates? Dates that exist in MS SQL?

     

    Best Regards,

    Jay

    • DNicoll's avatar
      DNicoll
      New Member
      5 years ago

      I was hoping the user coupl enter them. I had them hrd coded when I was first investigating the issue. 

      • DNicoll's avatar
        DNicoll
        New Member
        5 years ago

        Never post before coffee! I was hoping the user could enter them. I had them hard coded when I was first investigating the issue. 

         

        PS I can't see how you correct a post.