Hello,
I display in an email the current date using <%=odiRef.getSysDate( "MM/dd/yyyy" )%>. This works as planned. However, at times, I need to display instead the prior day. Is this possible using that ODI call? I've tried various things such as using a variable defined by a SQL schema below. I then reference variable in the email. However, This only displays the current date in the email.
SELECT CONVERT( VARCHAR(10), GETDATE(), 105 ) UNION
SELECT CONVERT( VARCHAR(10), GETDATE()-1, 105 )
I can create x numbers of variables that pull the correct date, though I would prefer to simply this process.
Any ideas would be appreciated. thanks.