4

I am using a tMap component. I have a date field with default pattern as "dd-MM-yyyy". I just need to insert a Blank Value. i tried '01-01-1900',"",TalendDate.getCurrentDate() : However they gave errors.

Is there a way to could only insert 01-01-1900 or a Null Value with datatype as DATE ?

Oggu
  • 323
  • 1
  • 6
  • 18

2 Answers2

2

Try TalendDate.parseDate() function...

DataRiver
  • 188
  • 1
  • 8
  • 21
1

you can simply either type null in expression in tmap or use TalendDate.parseDate("yyyy-MM-dd", "1900-01-01")

garpitmzn
  • 1,001
  • 6
  • 9
  • Thank you for the Answers. i used the TalendDate.parseDate("yyyy-MM-dd", "1900-01-01"), it worked good, – Oggu Feb 23 '16 at 15:02