Forum Discussion
Asantos2020
Advocate II
Advocate IIConvert Month Named Columns to Dates
Hello, I now have a table as the one below: Customer | Jan | Fev | Mar A 10 15 5 B 5 7 8 ...and I need to turn those month names into date...
I believe I am understanding correctly now.
So the MOTNH( ) function actually works opposite. You give PBI a month, and it returns a number that coorespondes to that date.
One way is the use = FORMAT(DATE(1, 4, 1), "MMM")
The returned value for this is 'Apr'
Let me know if this helps you out
I believe I am understanding correctly now.
So the MOTNH( ) function actually works opposite. You give PBI a month, and it returns a number that coorespondes to that date.
One way is the use = FORMAT(DATE(1, 4, 1), "MMM")
The returned value for this is 'Apr'
Let me know if this helps you out
Asantos2020Advocate II
Advocate IIWell...just so this date gets updated as the files coming overtime, I've done it this way, then: FORMAT(DATE(YEAR(TODAY());4;1);"dd/MM/yyyy").
Thank you! Cheers!