• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • Date format in query result

    #1

    This may be a simple fix. Does anyone know how to change the date format in a query result? We just upgraded to v6.3 and the query results when running against all protocols are displaying the date in yyyy/mm/dd format. My team would prefer this to display as mm/dd/yyyy.

    #2

    Hi @Michele_Park,

    Yes, it is possible to change the date format in the query result view, please refer to the ‘date_format’ function on the Wiki page.

    Thanks,
    Neha

    #3

    That is for an individual query. I’m curious if we can set a default date format for all queries created at any time. I would like to default the date format system wide.

    #4

    Hi @Michele_Park,

    Thanks for your inputs, we have fixed this in v6.3. The default format for the query result date field would be as per the locale set for OpenSpecimen.

    Thanks,
    Neha