Converting DATE to String and String to Integer in... - Qlik Community

Rohitash · ‎2019-04-24

Hi All,

I have a small requirement, where multiple conversion is required

Scenario

I have date field name X_DT and it's Datatype is DATE and on the other end it has NUMBER Datatype. So how to convert it ?

First conversion should be on STRING Datatype and then it should converted into INTEGER Datatype.

Kindly assist.

Regards,

Rohitash Sherigar

akumar2301 · ‎2019-04-24

Integer.valueOf(TalendDate.formatDate("yyyyMMdd", row1.datecolumn))

Rohitash · ‎2019-04-24

Thanks Abhishek for the assistant.

It's worked out really.

Could you please share the link of this function to write.Where I can reference it or future.

Anonymous · ‎2019-04-24

Please find the links below

Rohitash · ‎2019-04-25

Hi Abhishek,

I'm getting an java error. Please assist.

Please find attachment in the post.

Kindly reply.

Regards,

Rohitash

ERROR_LOG.PNG

Rohitash · ‎2019-04-25

Hi Abhishek,

As discussed my date format is in this form

DATE FORMAT : "yyyyMMddHHmmssSSS"

First i have to convert into string and then into number format.

So please suggest which datatype is suitable?

Float,Double, Integer or BigDecimal.

Please share the expression.

akumar2301 · ‎2019-04-25

Try Long

Long.valueOf(TalendDate.formatDate("yyyyMMddHHmmssSSS", new Date()))

If you want BigDecimal ,

new BigDecimal(TalendDate.formatDate("yyyyMMddHHmmssSSS", new Date()))

Converting DATE to String and String to Integer in TMAP