Hello, i need a solution for using functions on OQL Queries like e.g. Select CAST(EKDatum AS string) From MainModule.Artikel this works fine but the result is like 2023-03-11 23:00:00 So i would like to show only the date in a friendly way: 11.03.2023 Also something like trim, to cut unnecessary spaces.. Seems that no functions like substring or trim or… work with oql queries. Somebody here with an idea of getting this more friendly?
asked
Torsten Könemann
1 answers
0
Hi everyone,
i solved this by a MF and loop through every object and manipulte the strings before i use them in a select statement.