how to convert data type of decimal into datetime .

  • 19 September 2023
  • 2 replies

Userlevel 2

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 

I used field type convertor :-to achieve this but its not working ,any one can provide the configuration 


2 replies

Userlevel 5
Badge +1


May i know the date time format you are looking for.

@lakshmi_narayanan_t regardless of the date format you wish it to transform the value to you probably need to first change the value from a data type “DECIMAL” to data type “STRING” before you can then translate it to data type “DATETIME”. This is because the format of the input value is the format of the output value, as documented here. This also means that you will need to transform the values from the decimal format to a recognized data format, first. You can achieve this with the Expression Evaluator stage, perhaps with something like this (where “/date” is the name of the column your source datetime field is named/numbered):

${time:extractDateFromString(record:value("/date"),"MMM dd yyyy hh:mm:ss")}