Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Report URL issue in passing a DateTimevalue

Hi Team, I'm trying to pass a datetime value from one report to another report using Report URL as Hyperlink. From the Report URL filters documentation, i came to know that for DateTime type the va...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    By my confirmed and testing, you could refer to the url parameter for datetime type below.

     

    URL?filter=Table/Date gt datetime'2018-09-27T09:55:00'

     

    You also could have a test with my test sample file.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

I have had a contact with PG and will update here if I get any information.

 

Sorry for any inconvenience!

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Okay..

    Or is it possible to pass the value as String and make it available as a Text atleast in the destination report?

     

    What I'm trying to achieve is,

     

    My Source report is in Import mode and I need the Last refresh time of that Import mode dataset to be passed to the destination report (in Direct Query mode). This is because all the new records that are not yet refreshed in dataset will be highlighted in the destination report (Direct Query with Live data). 

     

    Is there any other way to get the Last refreshed time of Source dataset in my Destination report?

    Or is it possible to pass that as a string and have the value stored in a column so that i can use it for Conditional Formatting.

     

    Thanks

    SuryaVee

     

     

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi Anonymous,

       

      By my confirmed and testing, you could refer to the url parameter for datetime type below.

       

      URL?filter=Table/Date gt datetime'2018-09-27T09:55:00'

       

      You also could have a test with my test sample file.

       

      Best Regards,

      Cherry