Dataflow Refresh Error: DateTime operation failed because the resulting value falls outside the rang

Some questions: why are you specifying datetime but only feed it a date value ? Is that for incremental refresh?

And what's the reason for specifying the en-GB locale?  That shouldn't really be necessary?

Note that you are not creating a string, you are creating a datetime value.