Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RAJ6
Contributor III
Contributor III
‎2021-02-05 02:32 AM

How to convert date to number values in Talend

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

Labels (3)
Labels
184 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2021-02-05 06:07 AM

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

 

 

 

 

184 Views
0 Likes
RAJ6
Contributor III
Contributor III
‎2021-02-07 12:13 AM
Author

Hi @Sana SAFFAR​ 

 

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

184 Views
0 Likes
Anonymous
Not applicable
‎2021-02-07 09:31 PM

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

184 Views
0 Likes