Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display Date as text formate

Hi ,

 

my requirement is  , I had today() date function that time it will display the today date but instead of today date i need to display as text Todaydate  .

 

Ex : 2019-12-04 - Todaydate

 

when i select the todaydate text it needs to be filter today date values. kindly suggest me .

Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    HI Anonymous ,

     

    You can create a calculated column like below:

     

    Column = if('Table'[DateColumn]=TODAY(),"Today Date","Not")
     
    Please give Thumbs Up for support and also accept this as a solution if it helps you!

4 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    HI Anonymous ,

     

    You can create a calculated column like below:

     

    Column = if('Table'[DateColumn]=TODAY(),"Today Date","Not")
     
    Please give Thumbs Up for support and also accept this as a solution if it helps you!
    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      6 years ago

      Hi Anonymous ,

       

      I am glad that I helped you.

      Good Luck!

       

      Thanks!

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

     

    Try this.

    today = FORMAT( TODAY(), "YYYY-MM-DD" )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

    try

    = format(TODAY();"YYYY-MM-DD")

    it is the only read-format, filters should work ok

    do not hesitate to give a kudo to useful posts and mark solutions as solution
    Linkedin