Date and time diff

RVeitch_84 — Fri, 15 Nov 2024 23:49:26 GMT

I have a variable in a tMap that holds the hours and mins of a date diff, example result 02:15

I need to send that into excel and use it in a pivot table, but excel adds "1/1/1970"

So I was wondering if I instead of just holding the 02:15 in that variable can I add the current yyyy-MM-dd as a date.

So my file result into excel as a date would be 2021-08-21 02:15.

I think then I could parse out the hours and mins with hh:mm in excel?

Any help would be appreciated .

Unless their is a better way to do the date diff other than this:

TalendDate.diffDate(row29.Time, row29.CleaningTime , "SSS") ms
String.format("%02d:%02d", (Var.ms / (1000 * 60 * 60)) % 24, (Var.ms / (1000 * 60)) % 60) total_time
TalendDate.parseDate("hh:mm",Var.total_time) var1

Re: Date and time diff

Anonymous — Fri, 27 Aug 2021 03:02:48 GMT

Try this expression build the datetime format:

TalendDate.formatDate("yyyy-MM-dd",TalendDate.getCurrentDate())+" "+your_total_time_string

Regards

Shong