Forum Discussion

ARoldanPBI's avatar
ARoldanPBI
Frequent Visitor
7 years ago

Date format dd.mm.yyyy problem

Hey guys, I need the format dd.mm.yyyy as date but it only has dd.mm.yy, if i use a text field to generate dd.mm.yyyy i cant order as i would want because the field isn't date, someone can help me? T...
Need Help
ARoldanPBI's avatar
ARoldanPBI
Frequent Visitor
7 years ago

I keep having the same error, The value 'dd.mm.yyyy' isn't able to convert from Type Text to Type Date. @amitchandak

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 years ago

Can you create a new date column like suggested

 

Combine = mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4)

use that for sort or has the main date

  • ARoldanPBI's avatar
    ARoldanPBI
    Frequent Visitor
    7 years ago

    I cant use dd/mm/yyyy i need "." not "/" and with "." i cant convert to date amitchandak