HTML5 Data Bindings Formatter Support Product Page
Answered
Date sort - how to limit to a single month
Asked 15 Oct 2013 23:07:28
2
have this question
15 Oct 2013 23:07:28 Hope Tillman posted:
I'm looking to sort by date and just show the current month. I can sort by date and see all the records listed but not limit to a single month. I'd appreciate direction on this. Not seeing directions on this in the manuals. Replies
Replied 16 Oct 2013 08:34:39
16 Oct 2013 08:34:39 Teodor Kuduschiev replied:
Hello,
Using the HTML5 Data Bindings Formatter you can format your date to be displayed as a month only.
Using the HTML5 Data Bindings Formatter you can format your date to be displayed as a month only.
Replied 01 Feb 2014 00:04:06
01 Feb 2014 00:04:06 Steve Skinner replied:
I think what Hope is asking is how to restrict the records being output to a single month's worth - not how to format the date so it only shows the month.
Am I right on this Hope? If so, I'd love to know the answer to that as well.
Am I right on this Hope? If so, I'd love to know the answer to that as well.
Replied 01 Feb 2014 02:21:21
01 Feb 2014 02:21:21 Hope Tillman replied:
Actually that answer worked for me. I now have pages that restrict the output to a single month - for example:
November: www.esog.org/queries/201311.html
December: www.esog.org/queries/201312.html
January: www.esog.org/queries/201401.html
November: www.esog.org/queries/201311.html
December: www.esog.org/queries/201312.html
January: www.esog.org/queries/201401.html
Replied 01 Feb 2014 18:42:47
01 Feb 2014 18:42:47 Steve Skinner replied:
Sorry for misunderstanding. If you don't mind my asking, how did you set up the filter? I'm not quite clear on how this is done based on Teodor's advice.
Replied 02 Feb 2014 05:39:56
02 Feb 2014 05:39:56 Hope Tillman replied:
Steve,
I set up the filter of query.date with the contained value equal to entered value, and I entered yyyy-mm (i.e. 2013-10). Does that answer your question?
I set up the filter of query.date with the contained value equal to entered value, and I entered yyyy-mm (i.e. 2013-10). Does that answer your question?
Replied 02 Feb 2014 16:00:11
02 Feb 2014 16:00:11 Steve Skinner replied:
Ah yes. I thought maybe you were using some sort of filter based on whatever the current month is and I wanted to know how to do that, but I see you've hard coded the filter for a specific month.
Thanks!
Thanks!