this is my datetime values comes from xlsx file and i want to convert into proper datetime
VENDOR_CREATION_DATE COLUMN AS A decimal data type --->want to change datetime
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/1fde6076-a84c-43b4-989d-007b0a312a09.png)
I used field type convertor :-to achieve this but its not working ,any one can provide the configuration
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/6ef8ad86-7b4d-46bd-b2b8-7d9d705a7f37.png)