Covnert string date (yyymmdd) into a date (dd-mm-yyyy) as part of import

[dagland]

Hi All,

I am trying to import a data source into TM1 using performance Modeler, that has a date Number field (yyyymmdd) that I want to convert to a proper date for use as a date dimension. I have tried to use the following substring formulas but neither have worked:

vDate = Subst(The_Date_Number,7,2)|'/'|Subst(The_Date_Number,5,2)|'/'|Subst(The_Date_Number,1,4);
vDate = Subst(The_Date_Number,7,2)|'-'|Subst(The_Date_Number,5,2)|'-'|Subst(The_Date_Number,1,4);

I don't want to have to change the data source manually, prior to loading, so any suggestions would be appreciated.

Thanks
Danielle

[japwah]

try converting the date number to a string first, then use it in your formula.

strDateNumber = numbertostring(The_Date_Number);

[jimmy_k]

Never used before, but maybe this helps ...

http://users.skynet.be/fa436118/wim/tm1_newdateformatter_EN.htm