Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Changing date type

Hello All

Can anyone help for this below requirement , am getting unpareble date when am passing through tMap

I do i have a date format in MM/dd/yyyy and i need to change that date format into yyyy-MM-dd

 

example 

10/05/2019 to 2019-10-05

 

Thanks

Manish

 

 

Labels (3)
2 Replies
Anonymous
Not applicable
Author

Example

 

Input  

05/10/2019 

 

and in

output 

2019-10-05

 

i used  function but it did not worked to me

 

TalendDate.parseDate("MM/dd/yyyy",TalendDate.formatDate("yyyy-dd-MM" row1.Date ))

Sujay1
Creator
Creator

Hi @ksingh  try like this it worked for me. I tested and it worked for me.

TalendDate.formatDate( "yyyy-MM-dd",row2.dt)

0683p000009M87R.png

 

Output is like below:

0683p000009M87W.png

 

 

I added other date formats just in case if someone needs it.Happy to help.