Forum Discussion
Solved
Dynamic data retrieval based on today's date
Hi, I am trying to retrieve data for the most recent date from an SAP BW server. It requires me to query a parameter in the following format "[0FISCPER].[K4202003]" to retrieve March 2020 data. W...
oh, the solution I gave can easily be fixed... just add a 0 e.g.
yyyy0MM
What locale are you using.
If you create a new blank query with:
= Text.From(<<Your logic>>)
what is the ouput?
It was the error message from the SAP server that was confusing. I thought that my output from Text.From() was '03.2020', which didn't make any sense, but that was just SAP's interpretation. I got '202003', which was expected given the code, but I needed '2020003' with the extra zero for it to be a valid entry in SAP. Your proposed solution would have worked were it not for the extra zero.
Anyways, case closed. Thanks for the fast responses guys.
oh, the solution I gave can easily be fixed... just add a 0 e.g.
yyyy0MM