Query about data to be selected

AppSheet AppSheet Q&A
1

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?

2

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

1 Like
3

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

4

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

1 Like
5

For reference:

1 Like
6

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

1 Like