Ramdon Cell from Table

[seothtt 1]

I have a two part question.

 

I pull dates into a table, when I'm in my WP site, I want to pull a random date from that table and insert it into the date field. How do I pull random text vs increment one by one?

 

Second, the date format needs to be like, yyyy-mm-dd HH:MM:SS If I put that into excel and save it as csv it changes it to MM/DD/YY HH:MM:SS PM/AM. How can it ensure the date/time format stays the way it needs to be?

 

Thanks,

 

Richard

[JohnB 255]

I am not very familiar with Excel formatting so maybe someone else knows better, but here is some code to demonstrate choosing a randowm table cell:

 

navigate("http://www.ubotstudio.com/playground/simpleform.aspx", "Wait")

type text(<last name field>, $table cell(&dates, $rand(0, $table total rows(&dates)), 0), "Standard")

 

 

 

John

[seothtt 1]

Thanks JohnB that worked great.

 

Richard