Forum Discussion
add column with date format
I ve a column with this date format dd/mm/yyyy i would like to duplicate and transform in mm/yyyy in edit query
how i can?
1 Reply
Anonymous
Based on my test, we can transform dd/mm/yyyy/ to mm/yyyy in edit query by following steps.
1.Duplicate the column in query editor.
2.Add a custom column as below
Custom= Text.End([#"date - Copy"],7)
Regards,
Frank
