I am trying to create an expression for my conversion file that would map the external format in the flat file to the time dimension format as per example below:
External ===> Internal (BPC)
1/9/2018 ====> 2018.01.09
1/19/2018 ====> 2018.01.19
12/2/2018 ====> 2018.12.02
12/31/2018 ====> 2018.12.31