Forum Discussion

siac16's avatar
siac16
Regular Visitor
4 years ago
Solved

Wrong Date Format

Hi,   I'm having an issue with the date format of a calculated column. It should be dd/mm/yyyy in a long format, for example, Thursday, 16 of December of 2021. Unfortunately, for the first 12 day...
  • amitchandak's avatar
    4 years ago

    siac16 , Try like

    Date = date( left(Table_FACEBOOK_PAGE_DATA[periodo],4) , mid(Table_FACEBOOK_PAGE_DATA[periodo],5,2) , right(Table_FACEBOOK_PAGE_DATA[periodo],2))