DSXchange

Hi,

I am trying to default a column, with a Timestamp datatype, to '0001-01-01'. Is there a function that will do that? I typed in the 0001-01-01 and all that was returned were stars because I did not have a function. Any help would be great. Thanks!

StringToTimestamp. And you'll need a time as well, even if it's all zeroes.

StringToTimestamp(0001-01-01 00:00:00,[%"%yyyy-%mm-%dd %hh:%nn:%ss"%])

I input this and it isn't working.

I also took out the '%' in front and back of the quotes....

StringToTimestamp(0001-01-01 00:00:00,["%yyyy-%mm-%dd %hh:%nn:%ss"])

Try
StringToTimestamp("0001-01-01 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")

You need quotes around your string and there's no square brackets needed.

Also there's no need to quote everything all the time, rather than 'Reply with quote' simply use the Reply to topic link. Save the quoting for when it makes sense.