Setting default date value

lsnovick · Post by **lsnovick** » Mon Jun 04, 2007 9:06 am

I need to set a default value into a timestamp field. This does not work:

If IsNull(lnk_PassMbrId.END_DT) Then StringToTimestamp('9999-12-31 00:00:00',"%yyyy-%mm-%dd HH:MM:SS") Else lnk_PassMbrId.END_DT

Any idea on what gets it to work?

Thanks.

DSguru2B · Post by **DSguru2B** » Mon Jun 04, 2007 9:16 am

Your time format is not correct. Put the following in the format mask

Code: Select all

"%yyyy-%mm-%dd %hh:%nn:%ss"

Edwink · Post by **Edwink** » Mon Jun 04, 2007 9:23 am

Can you post the error message?

lsnovick · Post by **lsnovick** » Mon Jun 04, 2007 11:02 am

APT_CombinedOperatorController,0: Fatal Error: Attempt to setIsNull() on the accessor interfacing to non-nullable field "END_DT".

If IsNull(lnk_PassMbrId.END_DT) Then StringToTimestamp('9999-12-31 00:00:00',"%yyyy-%mm-%dd hh:nn:ss") Else lnk_PassMbrId.END_DT

Edwink · Post by **Edwink** » Mon Jun 04, 2007 11:07 am

hope DSguru2B reply would solve your problem

lsnovick · Post by **lsnovick** » Mon Jun 04, 2007 11:22 am

Nope. I tried that too.

If IsNull(lnk_PassMbrId.END_DT) Then StringToTimestamp('9999-12-31 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss") Else lnk_PassMbrId.END_DT

DSguru2B · Post by **DSguru2B** » Mon Jun 04, 2007 11:54 am

What is the error that you got when you applied my method? Are you sure that your incoming empty column is infact NULL and not an empty space?

lsnovick · Post by **lsnovick** » Mon Jun 04, 2007 12:00 pm

I fixed it by renaming the field coming in and it worked. That is so weird that I can't even understand how it works now.