subfield not working

[#1]

Subfield(created_time,'-',1) &'/'& Subfield(created_time,'-',2) &'/'& Subfield(created_time,'T',3)

thirs subfield should return 09 but it is not returning 09

[sunny_talwar · Accepted solution]

Try this instead:

Date(Date#(Left(created_time, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD')