Format Date Field in Output

Options
pgiesin
pgiesin Member ✭
in ? Transforming data

I have what I feel is a simple problem, yet, I can't find an easy solution. I have a table with a Date field that by default is returned as "2023-04-06" from the API to Wized/Webflow.

My requirement is to display the data as "April 04, 2023".

Is there a way to make Xano make this transformation before returning the final response?

Peter

· Share on Twitter

Answers

  • Ray Deck
    Ray Deck Trusted Xano Expert ✭✭✭
    Options

    Yes! There are date parsing and transformation filters in Xano. I would take the date, "parse_timestamp" it into a timestamp, and then "format_timestamp" into what you need. Here are on-point docs: https://docs.xano.com/working-with-data/timestamp

    · Share on Twitter

Categories