extract current month

  • Good evening, I’m trying to extract from the database all the records recorded in the current month, exposing the name of the workshop, name and surname etc etc but with the following shortcode does not give me any results. How can I do? Thank you

    [pdb_list filter=”data=current_month&officina=fabbro” fields=”officina,nome_e_cognome,targa,data_attivazione,data”]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author xnau webdesign

    (@xnau)

    The “current_month” value actually returns the first day of the current month, so you need to use the >= operator to get all the records with date values within the current month. Also, the “current_month” value can only be used for “date” type fields, in case your “data” field is not a date field.

    For example:

    [pdb_list filter=”data>=current_month&officina=fabbro” fields=”officina,nome_e_cognome,targa,data_attivazione,data”]

    Thread Starter pixalab

    (@pixalab)

    Thanks as always for the answer. I entered your code and I had no result. I tested the code myself and with this code [pdb_list filter=”data>-0_months&data<+1_months&officina=fabbro” fields=”nome_e_cognome,targa,data_attivazione,data”] I got what I wanted. I enclose screenshots https://drive.google.com/open?id=1mQ93Ge2dM1hhBYuffvqs_WnJ5XiFKely. It is likely that I will implement the search period selection with the plug I purchased (Datepicker extension). Thanks for the support

    Plugin Author xnau webdesign

    (@xnau)

    glad you got it working

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘extract current month’ is closed to new replies.