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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.