Today function in script

[#1]

Hello,

I am trying to formulate an if statement in the script so that a date of 9/9/1999 will be changed to the current date. Below is my statement:

if ([QMIH.MalfunctStart_AUSVN] = '9/9/1999' , today(1), QMIH.MalfunctStart_AUSVN) as adjustedDefectDate

however any occurence of 9/9/1999 now returns 40604. it's 3/2/2011 so I'm a little confused.

I've tried today(), today(1), and now()

Really weird. Can someone help me?

[#2]

Never mind I figured it out.

I used date(today(1)) and it worked!!