I'm trying to set up a Flowgraph in Web-based Workbench (SPS03) involving a History Preserving node. I have chosen the target table field for my Valid From column and there is a box for "Expression/Value" which I'd like to put in the current day's date/time. I have tried using now() and current_utctimestamp but I get the error message
sql syntax error: incorrect syntax near "" line 1 col 137913 (at pos 137913)
I guess it's something to do with the syntax I'm using but the documentation isn't much help - I've even tried creating a calculated column within the flowgraph with now() to give today's date/time but I can't see how to reference this either.
Any suggestions for the correct syntax to use?