date picker - Toolset

This support ticket is created 4 years ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Karachi (GMT+05:00)

Tagged: Custom search, Setting up custom fields, Types plugin, Views, Views plugin

This topic contains 1 reply, has 2 voices.

Last updated by Waqar 4 years ago.

Assisted by: Waqar.

Author

Posts

February 23, 2021 at 6:42 pm #1964553

davidW7647

Screen Shot 2021-02-23 at 10.41.24 AM.png

Screen Shot 2021-02-23 at 10.40.42 AM.png

Screen Shot 2021-02-23 at 10.40.50 AM.png

I have an ultimate member profile form.

On it i have date picker (onboarding).

onboarding_date
array (
0 => '2021/02/22',
)

Under query filter for my view I want to view only usermate field fiter
Select items with field:
onboarding_date is a DATE equal to THIS_MONTH()

Specifically I want the past 7 days.

However it's not registering that data at all.

Under Ultimate member I can use custom date format. It's set to jMY

That's pretty standard, but again, not registering.

February 24, 2021 at 7:38 am #1965119

Waqar

Hi,

Thank you for contacting us and I'd be happy to assist.

To effectively use date-time filters on values, it is recommended to store them in Unix timestamp format.
( ref: hidden link )

Toolset Type's date and time type fields also store the values in that same format and the date-time filters available in the views are also designed to work with that format.

This is why it is important that the date-time field values that you're storing through the Ultimate Member profile form, are also stored in that same Unix timestamp format "U".
( ref: hidden link )

I hope this helps and please let me know if you need any further assistance around this.

regards,
Waqar