Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add Current Month to day

Hello everyone, I have been trying to add the current month to this day, so It will show up correctly in my charts, so I can filter by date  , but for some reason instead of adding 02 February, it results  03 January. 

 

I need some help, please.

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago
    Column = DATE( YEAR(TODAY()), MONTH(TODAY()),'Table 5'[Day])

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Use DATE() function and include year(today()) also

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you Anonymous   ,  looks like something's not looking right,  still

      I'm an idiot , please advise 

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago
        Column = DATE( YEAR(TODAY()), MONTH(TODAY()),'Table 5'[Day])