on 2022 Aug 15 8:25 PM
Hi
I'm trying to load data from an ADSO to BPC. I've a problem with time conversion file logic. I need to populate FY22.JAN if the source record is coming with 2023001
Can you please provide the JS syntax guide or share the snippet of code to write in internal column for above scenario.
I am trying with below syntax.
js:(pasrseInt(%extrernal%.tostring().slice(0,4))-1).toString()+'FY'.'SUBSTR(-2,2).'JAN'
Thanks in advance
Chandu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nikhil,
Thanks for providing the corrected syntax. Going forward i will follow the testing approach using Java Script editor.
Regards,
Chandu Guduru
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
5 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.