Date format


#1

I need a date in this format " DD/MM/YYY "( not using native query).
Now date in string format “Friday, January 26, 2018 7:38 AM” So I couldn’t sort properly.

Can you help me?


#2

Hi, @lechu,

Build the question in builder and convert to sql then append

Date_format(@date, “%d/%m/%Y”)


#3

The next version of Metabase, 0.31, will also include lots of new options for formatting dates, numbers, and currencies without having to use SQL.


#4

Yay :slight_smile:


#5

Double yay :slightly_smiling_face: :slightly_smiling_face:


#6

When is the next version releasing?