Forum Discussion
siac16
4 years agoRegular Visitor
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...
- 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))
amitchandak
4 years agoSuper User
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))
- siac164 years agoRegular Visitor
Hi! it totally worked. Thank you so much