Formatting datetime

Good morning

I have a cube with a long date registred on it  with US  format 1/29/2018 3:50:28 PM

it is possible format a screen with this UE format  29/01/2018 15:50




  • Hello,

    as alternative to NEXEL, if the date has been stored as text you could also use a column algorithm with left(), right() or mid() formulas to parse day, month, year or hours, minutes and seconds. After you have parsed the different elements of the date you can then re-arrange the format as per your liking.


    You can read this section of the manual for further information on the formulas:


    Hope this helps



  • I found this NEXEL Formula handy for me and it could be great to have also in the column algorithm:

    =TEXT(DateValue([@a;*;*]);"yyyy-MM-dd HH:mm:ss")