I want to remove time format

[nagarajuchilveri]

Hi Guys,

I need a help!

above snap I need to  remove the time format.I have applied logic it's working but few places time has visible below snap.

I am using  this logic below.kindly help me.

Replace(Replace(Replace( [DEPDATE &TIME],SubField( TextBetween( [DEPDATE &TIME], '-','/'),'-',3),''),'-/','/'),Right(Replace(Replace( [DEPDATE &TIME],SubField( TextBetween( trim([DEPDATE &TIME]), '-','/'),'-',3),''),'-/','/'),7),'') as [DEPDATE &TIME1]

Thanks,

Nagaraj

[BrunPierre · Accepted solution]

Hi, You might want to consider this alternative approach:

Left(PurgeChar([DEPDATE & TIME],' '), 10)&' / '&
Mid(PurgeChar([DEPDATE & TIME],' '), Index(PurgeChar([DEPDATE & TIME],' '), '/',1)+1,10)&' / '&
Mid(PurgeChar([DEPDATE & TIME],' '), Index(PurgeChar([DEPDATE & TIME],' '), '/',2)+1,10)&' / '&
Mid(PurgeChar([DEPDATE & TIME],' '), Index(PurgeChar([DEPDATE & TIME],' '), '/',3)+1,10) as [DEPDATE & TIME 1];

[nagarajuchilveri]

@BrunPierre Thank You! It's Working.