How to convert date from mm/dd/yyyy to dd-mmm-yyyy

General
1

Hi,

I am retrieving a date and time from a table whihc is stored as mm/dd/yyyy but I would like to display it as dd-mmm-yyyy. I saw a similar question here but that references an Expression function in the column creation block which does not seem to exist anymore.

How best can I achieve this?

Thanks
Steve

2

Hi @Steve ,
This functionality exists, you can create a separate “Generated Column” in the database,
1 Go to Backendless Database
2 Select a table
3 Go to the “Schema” section
4 Click on the “New” button
5 In the opened pop-up, select the Generated Column checkbox
6 An additional field “Expression” will appear

image
image1276Ă—1372 67.2 KB

Regards,
Sergey

3

Hi Sergey,

Brilliant. That worked.

Steve

1 Like