FIlter
Permalink Browser Info Environment
In one of my forms I have a date picker field. In my data display list I am trying to Filter >> Sort my list by the date but I can't get it to sort the dates correctly. Am I needing to format that date view in the Form Field (in Advanced Forms) in a certain PHP format for this to appear correctly? At kind of a lose for this. Also is there a way to have empty fields appear last and the closest date at the top. Basically it is for our sales to have a way to input leads and be able to have a date when they need to contact them and the closest date located at the top. Thanks for the help and Merry Christmas.
Andy P.
Andy P.
| Type: | Discussion |
|---|---|
| Status: | In Progress |
I forgot to include that it is filtering but it shows February then January then March. I need it to sort at January = 01, February = 02, March = 03 and so on. Thanks and hope to hear from someone soon.
Your input dates need to be set as 2015-05-05, when adding to the form.
Then in the template set the date format however you wish it to be - 2 examples:
I can't recall the output, I think the first one displays as 5/5/2015 and the other maybe May 5, 2015. There's a link to date formatting in the form field.
Then in the template set the date format however you wish it to be - 2 examples:
<field name="Date of Death" format="m/d/Y" /> <field name="Date of Death" format="F j, Y"/>
I can't recall the output, I think the first one displays as 5/5/2015 and the other maybe May 5, 2015. There's a link to date formatting in the form field.
The dates in this addon are text fields, rather than date fields, thus the need for the proper date input.