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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
mani1304
Creator
Creator

Adding 1 minute in the parm file

Hi All,

 

I need to add 1 min to the parm file's end date and assign this time to FILE_NAME_TIME_STAMP context fieldname(which is string) and I am using TalendDate.addDate function for date and this is working fine for all times except for 12:29 and 12:59, Ideally it should make the date to 12:30 and 13:00, instead of this, date is modifying to 00:30 and 01:00, can somebody suggest on this and how to get the desired output.

 

TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.addDate(row1.end_dttm,1,"mm"))

Labels (3)
2 Replies
fdenis
Master
Master

check format of row1.end_dttm it may be set to 12 hour format
is row1.end_dttm a string?
if yes convert it first using TalendDate.parseDate(“yyyy-MM-dd’T’HH:mm:ss.SSS”, row1.end_dttm)
mani1304
Creator
Creator
Author

Spoiler
Spoiler
 

Thanks, it was hhmm there.