Convert date

[Former Member]

Convert date format yyyy-mm-dd to yyyymmdd ?

Could you please tell me how to convert?

thanks

roopa.

[Former Member · Accepted solution]

Hi roopa,

Convert date format yyyy-mm-dd to yyyymmdd ?

As per my knowledge, that is possible with standard function u201CDateTransu201D of the DATE group and set the input and output date formats as per your requirement.

Search in SDN, there are plenty of blogs, and forum threads.

thanks,

[Former Member · Accepted solution]

Hi bhavanhi,

Yes I know about DateTrans but If I use DateTrans function then getting space between yyyy and mm ,u2026.

How to remove space between yyyy, mm and dd ?

thanks

roopa........

[Former Member · Accepted solution]

hi roopa,

Okay. That is very simple Delete space between yyyy and mm , dd using by backspace.

Thanks,

[Former Member]

Hi,

Use the standard function "dateTrans". No need of a UdF or a function to remove '-'. Just do that:

Input = yyyy'-'mm'-'dd with simple quote to encapsulate minus character -.

output = yyyymmdd

Mickael

[anupam_ghosh2]

Hi Roopa,

you can use normal text replaceString function

date ---------------------->                   
Constant(-)--------------->        replaceString---------------------->target
Constant()--------------->

or you can try this UDF

public String TransDate(String a,Container container){
   //write your code here
try
{
	a=a.replaceAll("-","");
				
}
catch(Exception e)
{
       e.printStackTrace();
}
return a;
}

Regards

Anupam