locked
Can we use formatDateTime with @trigger().outputs.windowStartTime.?? RRS feed

  • Question

  • Hi,

    I have a dataset with query defind as below..

    @concat('SELECT * FROM GPMQ.BAT_C WHERE LST_UPDT_TS >','''',formatDateTime(pipeline().parameters.StDt, 'yyyy-MM-dd'),'''')

    my pipeline has a parameter StDt which getting @trigger().outputs.windowStartTime at the run time.

    the pipe line executes fine when i give a date ..for ex 2017-02-01 ,

    but it fails with this error below when i pass @trigger().outputs.windowStartTime.

    { "errorCode": "InvalidTemplate", "message": "In function 'formatDateTime', the value provided for date time string '@trigger().outputs.windowStartTime' was not valid. The datetime string must match ISO 8601 format", "failureType": "UserError", "target": "Copy Data1" }

    what am i doing wrong here.??

    Regards,

    Sai

    Wednesday, October 2, 2019 10:08 PM

All replies