Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

FORMAT IF STATEMENT TO "DDD DD MM YY"

Guys, is there a way to format the below to show the date format as DDD DD MM YY?  Thanks   Next 5 Days = IF(Query2[DateIn]=Today(), Today(), IF(Query2[DateIn]=Today()+1, Today()+1, IF(Query2[Date...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    Check below formula.

    Next 5 Days = 
FORMAT (
 IF(Query2[DateIn]=Today(), Today(), IF(Query2[DateIn]=Today()+1, Today()+1, IF(Query2[DateIn]=Today()+2, Today()+2, IF(Query2[DateIn]=Today()+3, Today()+3, IF(Query2[DateIn]=Today()+4, Today()+4,IF(Query2[DateIn]=Today()+5, Today()+5,IF(Query2[DateIn]=Today()+6, Today()+6, BLANK()))))))),
    "DDD DD MM YY"
)

    Regards,

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous you can use format function and pass the same expression to get the desired output

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for that.  Id try that but unfortunaely i am then unable to sort the graph by date.  For some reason it will not sort correctly

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous 

    You may use sort by column as below.

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thansk for that but the graph still cant be sorted correctly

       

      • v-cherch-msft's avatar
        v-cherch-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi Anonymous 

        Please check sort by option.

        Regards,