want to change (month-year) fromate into dd-mm-yyyy) formate

[yadav_anil782]

Dear All ,

i have Period_name column in my source table  but date format is different i wants to change  in( dd-mm-yyyy) format . plz give reply i can anyone solve this issue -

source sheet i attached 

[sunilkumarqv]

but its working for me

or something like this

Date(alt(MonthStart(Date#(purgechar(PERIOD_NAME,'_Adj'),'MMM-YY')),Date(PERIOD_NAME,'DD/MM/YYYY')

,Date(PERIOD_NAME,'MM-DD-YYYY'),Date(PERIOD_NAME,'YYYY-MM-DD'),Date(PERIOD_NAME,'YYYY/MM/DD')),'DD-MM-YYYY') as PERIOD_DATE,

[#3]

Hi

    Try like this it may work

date(date#(datefield,'mmm/yy'),'dd/mm/yy')

[yadav_anil782]

thanks Sunny,

its very helpful to me