I have a date column called Entry with a time field, and I want a column which just contains AM or PM based off the corresponding value in Entry. I seem to only get back AM with this formula: DATETIME_FORMAT(Entry,‘A’)
Thanks!
Thanks! Updating the Entry column’s field type to use GMT finally results to PM when appropriate. I happen to have been entering times at 8pm EST, and that’s why it kept showing AM.
