About EasyMorph Tutorials & Examples Web-help

Add "Time" format in format list

Hello,

In format list, there is no choice to time.
Can you add this format or add possibility to enter a format manually ?
image

Thanks.

It would be nice to have the option for custom formats here (as in Excel).
At the moment, I guess that only a modify will do this for you:

grafik

Kind regards,

Jochen

I get data from SQL server. If I format in “custom SQL”, I can no longer use the visual designer.

Without format, it’s not usable.
image

With format with time, displayed data does not mean anything.
image

After format in function, data are text. These are no longer numbers.
image

If you export result in Excel, this new column are text and you can make text filter only even when applying the time format in Excel.
image

In Excel, column with “time” format can be filtered as number. Here example with column in time format with value entered manually.
image

To learn more about EasyMorph visit easymorph.com.