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,

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,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks, so i have creatred a new column to format ie DAYS FORMATED = FORMAT(Query2[Next 5 Days], "DDD DD MMM, YY")  but i see above the format code is actually built into the Next 5 days formula.  How do i do that?  Many thanks for your help

         

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