Skip to Content
0
Nov 23, 2020 at 06:12 PM

XSC workbench History Preserving Valid From format

12 Views

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?