topic Re: I want to remove time format in App Development

I want to remove time format

nagarajuchilveri — Fri, 15 Nov 2024 20:59:37 GMT

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

Re: I want to remove time format

BrunPierre — Sun, 21 Apr 2024 09:27:10 GMT

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];

Re: I want to remove time format

nagarajuchilveri — Mon, 22 Apr 2024 05:20:46 GMT

@BrunPierre Thank You! It's Working.