String functions

[ChannaK]

{"index":1,"post_id":null,"changed_at":"2023-09-08T20:05:08.649Z"}

i need to extract data after "changed_at" , i need date but it should be based on "changed_at" 

because this position will change for each record

[Lisa_P]

TextBetween('"index":1,"post_id":null,"changed_at":"2023-09-08T20:05:08.649Z"', '"changed_at":"', '"')

Gives this: 

[fe-c]

You can combine subfield() & left() like:

left(subfield(temp,'"changed_at":"',2),10)

and get: 2023-09-08

[ChannaK]

=left(mid(TextBetween(value, 'changed_at' , '}'),4),24)