Confiform Datetime interval sorting

Markisio

Hi There

 

I have confiform with Datetime Interval field, when I display the data of that form and try to sort it by the Datetime interval it doesn't work, here is the details 

 

datetime interval field name is duration

 

in tableview, sorting by startDate of the duration: I did duration.startDate ASC

 

I notice its sorting it as a string, below is what get displayed

 

April 1, 2023

June 1, 2023

May 1, 2023

 

it seems its sorting by letters of the month rather by date. Please look at June and May

 

I tried using formatDate function: duration.startDate(MMM, UTC) ASC but no luck

 

please advise, much appreciated

Alex Medved _ConfiForms_

Hi

This works absolutely perfect for me when I try

With the storage format as below

<ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="8515674c-1fe7-4d03-abfc-920405ea6d51"><ac:parameter ac:name="formName">f</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="a835064e-d533-48b1-a114-ed27dfba04b1"><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="60a95d9a-36a3-4ac8-97bf-5a405cb899d8"><ac:parameter ac:name="fieldName">duration</ac:parameter><ac:parameter ac:name="fieldLabel">duration</ac:parameter><ac:parameter ac:name="type">datetimeinterval</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="14dac29d-5d9b-4deb-9b0a-4e366eb092a7"><ac:parameter ac:name="formName">f</ac:parameter><ac:parameter ac:name="sort">duration.startDate ASC</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>

Alex