Veeru
09-06-2017, 09:45 PM
Hi,
My issue is not big but I need it on urgent basis. I am trying to use concatenate formula on three items.
1. 1900 (Amount)
2.07-09-2017 (Date)
3. 12.78 (Amount)
When applying concatenate , it converts date into numbers hence result is something like this : 19004298512.78
But what I need is data format should be maintain and result should be like : 190007-09-201712.78
Please provide suggestion on the same.
Thanks
My issue is not big but I need it on urgent basis. I am trying to use concatenate formula on three items.
1. 1900 (Amount)
2.07-09-2017 (Date)
3. 12.78 (Amount)
When applying concatenate , it converts date into numbers hence result is something like this : 19004298512.78
But what I need is data format should be maintain and result should be like : 190007-09-201712.78
Please provide suggestion on the same.
Thanks