Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to Separate date, Time & Country in load
My Data contains like below
13/Apr/2017 19:32 Europe/London
01/Jul/2017 Asia/Calcutta
May be like this
Date#(SubField(FieldName, ' ', 1), 'DD/MMM/YYYY') as Date,
Time#(SubField(FieldName, ' ', 2), 'hh:mm') as Time,
SubField(FieldName, ' ', 3) as Country
May be like this
Date#(SubField(FieldName, ' ', 1), 'DD/MMM/YYYY') as Date,
Time#(SubField(FieldName, ' ', 2), 'hh:mm') as Time,
SubField(FieldName, ' ', 3) as Country
Sufield(yourfield,' ',1) as Date,
Sufield(yourfield,' ',-1) as Country,
If( Sufield(yourfield,' ',-1) <> Sufield(yourfield,' ',2),Sufield(yourfield,' ',2)) as Time
Thanks Your both function works