DSXchange

Good Morning,
I have a date field that shows the month and year , but the format is that way, " 12016 " but I want to show this way " 012016 " as include 0 left on the date ? I use the transformer the clause " Cats ( Oconv ( DataAtual , " DM [ 2 ] " ) , Oconv ( DataAtual , " DY "[4] ) ) " to generate the data .

thank you.

Cats?

Why not just do it all at once?
Now, that's off the top of my dusty head but should get you pretty close. That may leave a space between the two but you can use Convert to remove it.

Thank you before was that way with CATS, had already made ​​the move to Oconv ( DataAtual , " DMY " , " [2.4 ]" ) ---- but not yet solved the problem of the month , I believe it is something in sql server

Not sure what this conversation has to do with SQL Server.

So what happens if you use the code I posted, what is the resulting string?

Same result, "12016" i need to " 012016"

We know what you need. What is your target data type? It needs to be a string and I suspect you are putting it into a number which strips the 'not significant' leading zero. If you are using a string then post the actual code you are using, copy/paste from the transformer (don't hand type it).

Sorry, In the field is string database ( 6) in the transformer also like to know that the transformer is with drawing 'not significant ?