Forum Discussion

SarikaB's avatar
SarikaB
Regular Visitor
4 years ago
Solved

Sort End of Week

Hello Team,   I have created a End of week column in the CALENDAR table, however unable to sort it chronologically, How can I fix this? Here is my end of week formula cEOW = FORMAT([Date] + 4 - ...
  • AlexisOlson's avatar
    4 years ago

    FORMAT returns a text value but you probably want a date. What if you remove the FORMAT wrapper and make sure it's a date type column and format the display via the column tools?