Formating Date in PowerQuery

[MedExcels]

Hello,

Thank you all for your help.

I have a question about how to format a date in powerQuery. I want to format or convert for example 10115 to 01/01/2015 and 311215 to 31/12/2015.

Thank you very much

 

[anvg]

Hi
If your 10115 is a number then you could use udf-function, for example

let
    source = 10115,
    NumToDate = (this as number) as date =>
    let
        year = Number.Mod(this,100)+2000,
        month = Number.Mod(Number.IntegerDivide(this,100),100),
        day = Number.IntegerDivide(this,10000)
    in
        #date(year,month,day)
in
    NumToDate(source)

If it is a string, then use NumToDate(Number.From("311215"))
Regards,

 

[MedExcels]

Hi, I did what you show me but It dosen't work may be it depends on me because I am not experimented in PowerQuery
Would you like helping me by formatting the date directly in this file in this a link Document Cjoint
The date in the second column.

Thank you

 

[anvg]

Would you like helping me by formatting the date directly in this file in this a link Document Cjoint

Good Zippyshare.com - FBtlK5WkVjs_TEST-QUERY.xlsx
Regards,

 

[MedExcels]

Thank you very much anvg good job
Could you show me how to insert this function in Power Query by step (because I really need that for others files).