Formatting the result of a SELECT

[Luis_DfG]

Hello!

I have the following case.

I have a column with a list of dates, let's say it exists in column Visit[assigned_date]

I'm trying to build a Enum that shows a unique list of dates formatted with month and year: "mm/yyyy"

In that line I tried the following:

SELECT(TEXT(DATE(Visit[assigned_date])),([customer_id] = [_THISROW].[customer_id]),TRUE)),"MMM")

but it didn't work.

Is it possible to format the output of a SELECT function? or should I break this down into two different columns?

[Steve]

This isn't SQL, you can't modify the output within the SELECT() statement itself. Try TEXT(DATE(SELECT(...))).

[Luis_DfG]

Thanks Steve!
I tried this approach as well but it didn't work as I expected. I followed a different approach.

[SkrOYC]

Add another column to the Visit table with a TEXT([assigned_date], "MM/YYYY") and then change your Select() with the new column.

SELECT(TEXT(DATE... makes no sense.

SELECT() - AppSheet Help

[Luis_DfG]

Yup! I went with this approach after posting the question.
What makes or doesn't make sense is what we are trying to figure out with what we have at hand:)

[SkrOYC]

What makes or doesn't make sense is what we are trying to figure out with what we have at hand:)

I guess so. I'm the kind of person that reads manuals so I "figure out" is kinda out of my mind. But we all make mistakes