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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nrao1693561508
Contributor II
Contributor II

How to add Z Character

Hi Team,

How to add "z" at end as last character:

input :

"2023-08-18T05:51:35.523970"

output should look like

"2023-09-19T14:33:07.597195Z"

Labels (4)
3 Replies
Anonymous
Not applicable

Hello,

You are able to convert your date into another String formatted and parse it back as you state

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'", row1.date)).

Hope it helps.

Best regards

Sabrina

 

 

nrao1693561508
Contributor II
Contributor II
Author

Thanks for your update Sabrina.

Anonymous
Not applicable

Hello,

Feel free to let us know if it helps and any further help we can give.

Best regards

Sabrina