Hello
I have the following query, which gets me the date I need:
SELECT CAST(FldValue - 2 as smalldatetime) as Date FROM WflowFields WHERE WflowNr='286' AND WfPageNr='78' AND LineNr='93'
With the above, the result I get is: 2019-12-31 00:00:00
However, I need the date in the UK format: 31-12-2019
I have tried incorporating the CONVERT function into my query, but I don't think I'm understanding how it works properly, and I am not getting the result I want.
Can anyone help?
Kind regards.
Taryn