topic Re: TMap - Date Format in Talend Studio

TMap - Date Format

Anonymous — Sat, 16 Nov 2024 05:11:54 GMT

Hello,

I need to insert a specific format in the Name field of a Salesforce object.

Example: Name: F - Check - 19-06-2019 - 30-06-2019.

The first date is the date of today.

The second date is the end of the month date.

In my tMap I used:

- TalendDate.getLastDayOfMonth (TalendDate.addDate (TalendDate.getCurrentDate (), 0, "MM")): for the end-of-month date

- TalendDate.getCurrentDate () for today.

The result is as presented: F - 20190614 - Wed 31 Jul 04:56:40 CDT 2019 - Tue. Jul 23 04:56:40 CDT 2019

Can you help me adapt both dates?

Thank you.

Re: TMap - Date Format

vapukov — Tue, 23 Jul 2019 11:31:34 GMT

Hi,

you just need convert date to string

TalendDate.formatDate("dd-MM-yyyy", TalendDate.getLastDayOfMonth (TalendDate.getCurrentDate ()))  - end of Month

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

Re: TMap - Date Format

Alexis_Sandvik — Fri, 03 Apr 2020 09:46:38 GMT

Hello ,

I just start to working with Talend Studio, its great .

I try to insert the Date in my output file in new column with this var ( talendDate )

but i have an error message .

could you help me ?

Alex

@vapukov wrote:

Hi,

you just need convert date to string

TalendDate.formatDate("dd-MM-yyyy", TalendDate.getLastDayOfMonth (TalendDate.getCurrentDate ()))  - end of Month

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

Re: TMap - Date Format

Anonymous — Fri, 03 Apr 2020 10:01:23 GMT

@Alexis_Sandvik , you don't use the function correctly, go to Repository-->Routines-->System and open the TalendDate routine, you will read the source code of this function.

addDate(Date date, int nb, String dateType)

If you can't still get it works, please describe your requirement with a bit details.

Regards

Shong

Re: TMap - Date Format

Alexis_Sandvik — Fri, 03 Apr 2020 15:42:07 GMT

Thanks for your feedback

Its working fine with ==> TalendGetDate for add the current date in new column