Query about data to be selected

[Yesenia_Leon]

Dear Sirs:

We want to select all the data in a field that is of the date and time type, how can we do so that this selection maintains its same format. Any ideas?

[Marc_Dillon]

Are you implying that you have already gotten the information, but it is a different format? How did you do so?

[Yesenia_Leon]

Hello Marc:
I just did the following statement:
SELECT (Table [Select Field], true)

[Marc_Dillon]

So what is the original data, and what is being returned?

[Steve]

For reference:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Yesenia_Leon · Accepted solution]

Thanks for your help. I was able to fix it by placing the TEXT () statement so that it maintains its same format.