Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
Hi
Try like this it may work
date(date#(datefield,'mmm/yy'),'dd/mm/yy')
thanks Sunny,
its very helpful to me