Graphics

No, not that kind of date...I'm not *that* lonely. :-)

Brand spankin' newbie here--we literally put our system on the air a week ago tonight--and I'm just staring to dip my toes into DataLinq.  We've got a graphic we run each day with almanac-style data on it (date in MM/DD/YYYY format, sunrise time, sunset, etc.).  I've got a tab-delimited text file imported into DataLinq and have it set up where when one of the producers inserts the graphic into their rundown, they can simply select the date from a list of available dates and the rest of the fields will populate from DataLinq.

What I'd really like to do is to automate the process, where the scene can automatically populate the fields with the appropriate data based on the system date.  I built a hidden text field fed by a widget with the date in a matching format, but I'm not sure how (or if there's even a way) to use the text of that field to then select a line in my DataLinq source.

Can anyone point this newbie in a good direction?  Thanks!

I feel like this would be possible if you were able to bring in the data under an ADODB source in to datalinq. (Excel, Access, MySQL)

Because (and I could be wrong about this), you can then run SQL queries on the data, which can handle date and time comparators.

Is that a possibility?

It's just a tab-delimited plain text file.  I could probably flip it around in Excel and do it that way, but it sounds like it's starting to jump through some hoops where it'll end up being easier to just get the producers to do it manually.  I was just sort of hoping there was some magic button I was missing somewhere...:-)

Thanks!