Showing Event date in Guardian List

[firlandsfarm]

We have the Time of an event available in the Guardian list but how can I get the Date of the event to show. When I import the list grid into my database I am currently adding the date manually and when it includes Asian and Antipodean I have to check when midnight is crossed.

[firlandsfarm]

I can't find a solution to this, have I missed something? It seems a fundamental bit of data and the data must be available because the time is grouped by the 'hidden' data but I don't know if the next Time group is the next day..

[Anbell]

I can't find a solution to this, have I missed something? It seems a fundamental bit of data and the data must be available because the time is grouped by the 'hidden' data but I don't know if the next Time group is the next day..

I'm not sure if this solves your specific problem, but there's an answer on this here website about using 'seconds till event start' and then converting that to days or dates or something. I used to use a version of it but cant find it quickly for you

[firlandsfarm]

I can't find a solution to this, have I missed something? It seems a fundamental bit of data and the data must be available because the time is grouped by the 'hidden' data but I don't know if the next Time group is the next day..

I'm not sure if this solves your specific problem, but there's an answer on this here website about using 'seconds till event start' and then converting that to days or dates or something. I used to use a version of it but cant find it quickly for you

That sounds interesting Anbell ... thanks for the tip, I will try it.

[firlandsfarm]

I'm not sure if this solves your specific problem, but there's an answer on this here website about using 'seconds till event start' and then converting that to days or dates or something. I used to use a version of it but cant find it quickly for you

That sounds interesting Anbell ... thanks for the tip, I will try it.

It's looking good at the moment Anbell, thanks again. I am now waiting for midnight to grab the number of seconds and divide out with rounding to the lower whole number to get the number of days ... I can't see that I can get the date into an SV but no worry, to have the number of days to kick-off in a column will do fine. The other thing I don't know is if the Fixed Time & Date rule trigger only activates the one time or if it activates every day at the time (so the days to kick-off will reduce). If it works I'll post it in case others find it useful.

[Anbell]

I'm not sure if this solves your specific problem, but there's an answer on this here website about using 'seconds till event start' and then converting that to days or dates or something. I used to use a version of it but cant find it quickly for you

That sounds interesting Anbell ... thanks for the tip, I will try it.

It's looking good at the moment Anbell, thanks again. I am now waiting for midnight to grab the number of seconds and divide out with rounding to the lower whole number to get the number of days ... I can't see that I can get the date into an SV but no worry, to have the number of days to kick-off in a column will do fine. The other thing I don't know is if the Fixed Time & Date rule trigger only activates the one time or if it activates every day at the time (so the days to kick-off will reduce). If it works I'll post it in case others find it useful.

Good work.

I can't quite remember how I used it, but here are some remnants of the logic if it helps

image_2024-07-25_205244665.png

[Anbell]

It's slowly coming back to me. I think I put it in a custom column and could then sort from there, and then apply different automations based on the 24 hour cycle

[firlandsfarm]

That sounds interesting Anbell ... thanks for the tip, I will try it.

It's looking good at the moment Anbell, thanks again. I am now waiting for midnight to grab the number of seconds and divide out with rounding to the lower whole number to get the number of days ... I can't see that I can get the date into an SV but no worry, to have the number of days to kick-off in a column will do fine. The other thing I don't know is if the Fixed Time & Date rule trigger only activates the one time or if it activates every day at the time (so the days to kick-off will reduce). If it works I'll post it in case others find it useful.

Good work.

I can't quite remember how I used it, but here are some remnants of the logic if it helps

image_2024-07-25_205244665.png

Yeah that's roughly how I'm doing it except I'm going for Days so I'm using the seconds from the previous midnight combined with the kick-off time does it for me. I just want to say OK, starts in 2 days at hh:mm. I will use the BA Start Time column to sort the order (which is why BA must have the data and use it to sort by Start Time order, why not display it?).

[buyshirts]

Hi did you ever come up with a solution to get the Date i could do with as a stored value because i want to use it to extract the day as i only want certain auto's to run certain days at certain dogs track.
Ive started to look into extract the Date from the Market name,Did you try that?

[Atho55]

I managed to get it using 2 stages but with a date with double digits ie 16th you would have to change the digits from right value or create another SV

Date as SV.png

Date in Log.png

[buyshirts]

Thanks Ath55 for that

I just thought of this can we not create a historical list with dates ie 4th June, 5th June, 6th june etc and then Text comparison to trigger?