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: 
Anonymous
Not applicable

Fetching tomorrow date's data (addDate function) from DB

Dear guys ,
I have three tables with relations. table1 , table2 and table3
Table1 fields :
t1_userid       ( Foreign key of t3_userid )
t1_appid        ( Foreign key of t2_appid )
t1_date
Table2 fields:
t2_appid (Primary Key)
t2_appname
Table3 fields:
t3_userid (Primary Key)
t3_username
Now i want to fetch tomorrow date (t1_date) data's
So i designed job like this

0683p000009MCeO.png
0683p000009MCeT.png tjava component (add_date)
String d=TalendDate.getDate("YYYY-MM-DD");
String ad=TalendDate.addDate(d,"yyyy-MM-dd",+1,"dd");
 
Tomorrow's date i will get from tjava component (add_date)
I want to construct a output with t1_appname , t3.username and t1_date (tomorrow's date) fields
 
Help me to do this
Thanks & Regards,
Vinoth Kumar K
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi Vinoth,
I would suggest you to make use of global map. 
Get current date - > add a day -> put the new date in global map  and then get that value where ever you need it.
Date date = TalendDate.getCurrentDate();
Date toDate = TalendDate.addDate(date, 1,"dd");
globalMap.put("toDate", toDate);
Or if you want date as string.
String date = TalendDate.getDate("yyyy-MM-dd");
String toDate = TalendDate.addDate(date, "yyyy-MM-dd", 1, "dd");
globalMap.put("toDate", toDate);

Now in the expression field for t1_date put this 
globalMap.get("toDate")

You can use date as it is if column type is Date, you can specify the date format there.