Countdown Timer - 14 days from specific date & time

[Ash1]

Hi guys,

I’m trying to use the countdown timer to countdown 14 days from a specific date & time field in my collection. Essentially, a user can buy a discount card that is valid for 14 days and I want to display this to them.

I was hoping to be able to use the date & time field + 1209600 seconds (14 days). This doesn’t seem to work though and it currently starts counting down from 14 says, 5 hours, 13 minutes and 47 seconds. I’m not sure if I’m completely missing the obvious and my calculation is just wrong (it’s been a long day!). Can anyone help?

Thanks,
Ash

[Erik]

Hi Ash,

I would create both fields at the same time: purchase date, expiration date (2 weeks after current date/time).

It should be easy to show it once you’ve done that and it’ll be easier to show on the voucher pages etc without using logic.

[Ash1]

Thanks for the reply @Erik

I’ve created a expiration date as you’ve suggested but I still can’t get the timer to display correctly. What should the formula be in the countdown timer to countdown to the expiry time?

[Erik]

You’ll want to double check this, but from a quick test, I did:

(expirationDate - purchaseDate)*86400

seems to work.

[Ash1]

Thanks @Erik

That didn’t quite work but I found a tutorial by Victor which walked me through it. Essentially I needed another property in the order collection which works out of the amount of seconds between the start and end dates. That value is then used for the countdown timer.