How to convert date to number values in Talend

[RAJ6]

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

[Anonymous]

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

[RAJ6]

Hi @Sana SAFFAR​ 

I tried it all date functions. it's not working. Please help me to find the correct number.

[Anonymous]

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