change from YYYY/MM/DD to DD/MM/YYYY

[chapeau_melon]

Can you help me in defining a calculation that transforms a date from YYYY/MM/DD to DD/MM/YYYY.

Kind Regards

[Lee Smith]

Hi chapeau_melon,

I think this calculation will do what you want.

Let([

Parts=Substitute(

YourDateField; ["/";" "]; ["-" ; " "]);

Month=RightWords(Parts;1);

Day=MiddleWords(Parts;2;1);

Year=LeftWords(Parts;1)];

Day &"/"& Month &"/"& Year)

HTH

Lee

[Raybaudi]

or:

Right ( yourField ; 2 ) &"/"& Middle ( yourField ; 6 ; 2 ) &"/"& Left ( yourField ; 4 )

The Lee's calc contains a little "bug"; the right calc is:

Let([

Parts = Substitute(

YourDateField; ["/";" "]; ["-" ; " "]);

[color:red]Day = RightWords( Parts ; 1 ) ;

[color:red]Month = MiddleWords( Parts ; 2 ; 1 );

Year = LeftWords( Parts ; 1 )];

Day &"/"& Month &"/"& Year)

[chapeau_melon]

Thx a lot, Lee calcs works very nice except I had to switch Day and Month.

The second solution works also like a charm !

Edited March 13, 2007 by Guest