topic Re: How to convert date to number values in Talend in Talend Studio

How to convert date to number values in Talend

RAJ6 — Sat, 16 Nov 2024 00:40:48 GMT

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

Re: How to convert date to number values in Talend

Anonymous — Fri, 05 Feb 2021 11:07:36 GMT

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

Re: How to convert date to number values in Talend

RAJ6 — Sun, 07 Feb 2021 05:13:06 GMT

Hi @Sana SAFFAR

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

Re: How to convert date to number values in Talend

Anonymous — Mon, 08 Feb 2021 02:31:43 GMT

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