Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issue in displaying date format

Hi,   I have a date format in a slicer like 202106 and 202405. I want to show these dates in an alphabetical way like "June 2021 to May 2024".  I have data from the backend that starts from 1990 ...
Need Help
Show and Tell
AsNa_92's avatar
AsNa_92
Resolver II
2 years ago

is this a text box?

Try to create a table and in the values put the earlist date and latest date:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    Yes, I have used text box for that to display the selected dates. 
    creating a table and used the date as you have mentioned. It didn't work out.

     

    my apologies, I might not be more specific about the issue. Let me try to explain clearly.

    As I have taken a slicer(between[to be specific]) "from date" and "to date". If I try to change from date and entered a date, the "to date" automatically goes to 2040. Cause it is choosing the max date from the table .

     

    Likewise, with the minimum date.
    If I select any specific date either from or to date, I want to see the exact same dates to be displayed as the input.
    Thanks in advance.