Todate() formula

[former_member672351]

Hi Communauty

I have an issue with TODATE() formula.

Endeed, from extracting data from this string 2020-03-15 (I can't use as date), I extract :

1) Left(XXXXX;4)=2020 = year

2) Substr(XXXXX;6;2)=03 = Month

3) =Right(XXXXX;2)=15 = day

4) I concat 1+2+3 = 20200315

Finally, when I use Todate(20200315;"mmddyyyy") the result is 01/15/2020

Day is correct =15

Year is correct =2020

But MONTH is not correct = 01

Some one can help me ? Please

CHRISTIAN

[mhmohammed]

Hi Christian,

For Month you need to use upper case MM, instead of lower case mm, as Todate([String object];"MMddyyyy").

Check this out
https://blogs.sap.com/2013/11/21/how-to-use-formulae-to-change-date-and-time-formats-in-webintellige...

Thanks,
Mahboob Mohammed