Forum Discussion
Solved
undefined
The FORMAT function for date is returning the date on Dd-MM-YYYY instead of Month when given Column = FORMAT( CONTRACT[CONTRACT_DT,"DDDD"])
v-kpoloju-msft Thanks for checking It started working when I have given the correct the given format.Thanks FBergamaschi
FBergamaschi ,Thank you very much for your reply. I have tried the above format as well, its returing the exact date in the new column instead of returning month when given MM and day when DDDD is given....! Is there any settings that I can do in my BI tool for my FORMAT function to work properly?