danielolaru1991

Exactly what I needed. THanks a lot ??

Solved!

Solution -> show_only=”newest” !

Bump! can any1 confirm if it’s possible or not? if not can you please implement this in future updates? It would be more than awesome ??

Problem solved. Thanks alot for your time and effort. For others that might encounter similar problems, here is my final working shortcode.

[cfdb-datatable form=”myform” trans=”numdate=strtotime(appointmentdate)&&appointmentdate=date(‘d-m-Y’,numdate)” hide=”Submitted,Submitted Login,Submitted From,numdate” permissionmsg=”true” class=”stripes” filter=”strtotime(appointmentdate)>=strtotime(today)” orderby=”numdate ASC” dt_options=”bJQueryUI: true, aaSorting:new Array()”]

If you have problems filtering your dates: “>” = “>” and “<” = “<”

Ok here is the shortcode I’m using:

[cfdb-datatable form=”myform” hide=”Submitted,Submitted Login,Submitted From” permissionmsg=”true” filter=”strtotime(appointmentdate)>=strtotime(today)” orderby=”appointmentdate ASC” dt_options=”bJQueryUI: true, aaSorting:new Array()”]

Which works great if the appointment dates are saved as Y-m-d by the cf7+datepicker plugin. Again, the problem is I need the dates to be shown as d-m-Y in the datatable. I tried to submit the dates to database as d-m-Y but the sorting is not working this way. If u need me to be more specific I can come back with some screenshots to make myself more clear. Ty for your time and effort.

Ty for the fast reply. Let me give you more info about what im trying to accomplish. I’m trying to build an appointment system for a clinc with cf7 and list the data on a datatable with the help of cfdb. The fields that patients fill are: name phone email appointmentdate. I need to sort by appointmentdate not by submit time. If date is stored as Y-m-d sortby=”appointmentdate ASC” works great. The problem is if I store dates as d-m-Y sorting messes up and i need dates to be shown as d-m-Y in the table. Ill paste the shortcode i use when i get to work in 1h maybe it helps. Great plugin btw.