Sort Line Chart by Timestamp Dimension

[#1]

Hello,

Thanks for looking at and reading my question.

I have created a line chart that has x-axis value as timestamp format. I already tried the following option however its not sorting properly.

I want the data to be sorted till minute precision.

Properties -> Sort -> Expression ->

//date(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi')

//BEGIN_INTERVAL_TIME

//=num(date(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi'))

//(Date(Date#(Left([BEGIN_INTERVAL_TIME],10),'MM/DD/YYYY'),'MM/DD/YYYY'))

//Time#(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi')

//time(frac(BEGIN_INTERVAL_TIME))

Please suggest what should I use to get the correct sort order.

Regards,

[#2]

Thanks for the hint. I tried following to load and its working now.

date(BEGIN_INTERVAL_TIME, 'MM/DD/YY hh:mm:ss') as BEGIN_INTERVAL_TIME