Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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];
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];
@BrunPierre Thank You! It's Working.