Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I need to convert date to number values in Talend. Below format to
converted date to number in excel using the =NUMBERVALUE(A2)
formula. I need to convert the date same as in Talend. Kindly provide a solution for this scenario.
Date formula
01.01.2017 42736
02.01.2017 42737
Hello,
You can try to use tMap component and use different functions that can be applied to a date.
You can check some scenarios here:
https://help.talend.com/r/qKn3z_Eiw4JM~sZ515DcOw/o_LXMYvloz~e2wSOyrw4Lw
Hi @Sana SAFFAR
I tried it all date functions. it's not working. Please help me to find the correct number.
Hi
The number value of a Date in Excel is the number of days since 1900-01-01. In Talend, you can use this function to convert a date to the number value on tMap or tJavaRow.
TalendDate.diffDate(TalendDate.getCurrentDate, row1.DateColumn, "dd")
Regards
Shong