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[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())))))))
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,

7 Replies

  • 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