Hi, I am trying to find documentation for the syntax used in the expression builder of the set variable activity in the automation tab of TDA.
I have two issues. I am trying to derive a date in the MMYY fomat that is three months ago from the current date. I can get it to work by using the following, but I need a way to pull the MM format of the month or pad the string that I’m pulling.
LEFT(FormatDateTime(DateAdd(“m”,-3,Now),vbshortdate),1) & Right(FormatDateTime(DateAdd(“m”,-3,Now),vbshortdate),2) pulls 610
The second issue I have is that when I hardcode the variable to 0610 and then use it in a find and replace activity TDA is truncating the 0 and replacing the text as 610 which then breaks my sql.