Get yesterday's date and convert it to a string in yyyy-MM-dd format?

[Anonymous]

Hi, I would like to get yesterday's date and convert it to a string in the format 'yyyy-mm-dd'
Here is what I have tried in a tJavaRow component:

outputFile.row = StringHandling.EREPLACE(tJava.row,"d",TalendDate.addDate(TalendDate.getCurrentDate(),-1,"dd").toString());

This is working but gives an unformatted date
I have looked at the tJava component but don't understand how it is meant to work
See my job design attached
Thank You

[Anonymous]

I would not do this in a tJavaRow. Use a tMap and set for the column you want this expression:

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

[Anonymous]

Hi, thank You this code worked