[Resolved] Conditional output on a date + hour

[Author]

Posts

[Pat]

Hello,

I'm trying to place a conditional output based on a date + hour. This is used to display the buy button only after a specific date (which is a custom field 'wpcf-date-prevente').
Here is my condiiton :
[wpv-conditional if="( $(wpcf-date-prevente) lte 'TODAY()' )"]
My custom field is a date + hour field. I found an issue when the date is the current date :
- If the hour is 00 00, then it works and the button is displayed.
- If anything else than 00 00 for the hour, then nothing is displayed.

Could you check and tell me if it is possible to use a date / hour field to manage this condition?

Regards
Pat

[Jamal]

Hello Pat and thank you for contacting the Toolset support.

TODAY() will always return today's date at 00:00:00. Any value of "date-prevente" that has time in today will be greater than TODAY().

I'll suggest that you substruct a day in seconds from the value of "date-prevente" and compare it, the following code should work:

[wpv-conditional if="( ( $(wpcf-date-prevente) - 86400 ) lte 'TODAY()' )"]

Let me know if this is not working.

[Pat]

Hi Jamal,

Thanks for your answer.
The issue with your proposal is that I need to use the date / time that is stored in the custom field. The aim is to allow the buying of a product after a certian date / hour that is defined thanks to this custom field. For info, this date / time is not the same for all products, so I cannot use your proposal that uses the same delta for all products !

Can you explain how th "TODAY" parameter is managed? Is it only a date or could it be a date / time?

Regards
Pat

[Jamal]

TODAY() returns a DateTime, the date of the current day at the time 00:00:00.

Can you elaborate more on the use case? Provide an example so I can understand better?

[Pat]

Hi Jamal,

Let's take this example :
Product A has to be in sales on october, 10th at 10AM
Product B has to be in sales on November, 4th at 4PM

So, I have the custom field "date-of-sales" which is a date field and is part of the products. So, I have set the right values for each product.

Now, I have a product template in which I have placed a conditional output on the buy button thanks to this code : [wpv-conditional if="( $(wpcf-date-of-sales) lte 'TODAY()' )"]
If I place the date with an hour equal to 00 00, this is working. If I try with a specific hour (like 10 00 for example), this is not working ! This sounds as if the fact to use the hour in the custom field is breaking something?

Hope this helps.
Regards
Pat

[Jamal]

Hello Pat,

But, I think, to still need more details about this. What do you mean by it does not work when using another time than 00 00?
Can activate debug on the shortcode and check the debug info:

[wpv-conditional if="( $(wpcf-date-of-sales) lte 'TODAY()' )" debug="true"]

Since, you are using datetime on your custom field, why not using a function that will return the time such as SECONDS_FROM_NOW(int)

[wpv-conditional if="( $(wpcf-date-of-sales) lte 'SECONDS_FROM_NOW(0) ' )"]

[Pat]

Hi Jamal,
Thanks for helping.

The parameter 'SECONDS_FROM_NOW(0) ' is working fine for me. Sorry, I did not see the documentation on this at that page : https://toolset.com/documentation/user-guides/views/date-filters/
I think the NOW() parameter should work fine, anyway, the SECONDS_FROM_NOW(0) fully work for my case.
I also see that the TODAY() parameter is blocked at 00h00m, which explains my issue.

Regards
Pat