I'm working on some scripts and am having problems pulling B_Posted & B_Last_Post from the database. It acts as though there is nothing in the field. Here's what I'm trying to do:<br /><br /> <pre><font class="small">code:</font><hr><% TestPosted = DateAdd("s", B_Posted, "01-Jan-70") %> </pre><hr> <br /><br />This is an asp script that is to convert unix time to normal time.<br /><br />It just keeps spitting back the epoch. All of the other fields are pulled without any problem, it's just B_Posted & B_Last_Post. Does anyone have any insight or suggestions? Thanks

What happens if you don't run DateAdd() on the value, does it come out right then?

The strangest thing happened. I worked on this all day yesterday, and even if I tried to display the raw data for B_Posted, nothing would display.<br /><br />Today I go to play with it, hit refresh and it worked. DateAdd is definately the way to go for converting the unix timestamps. Thanks anyway, I feel silly now <img src="/forum/images/icons/confused.gif" alt="" />