Hi. I am trying to patch to a DateTime field in my source. I need to patch Now() with formatting, like this:
DateDeleted: Text(Now(),"[$-en-GB]yyyy/mm/dd hh:mm")
but I get the error "The type of this argument 'DateDeleted' does not match the expected type 'DateTime'. Found type 'Text'."
I understand the issue. I just need to patch Now() as a DateTime format but with "[$-en-GB]yyyy/mm/dd hh:mm".
My problem is that Now() gives me time 2 hours behind the current time. If I use the en-GB format, I get the correct time.
I know I can do this but hopefully there is a way without a workaround:
DateDeleted: DateAdd(Now(),2,Hours)
Solved! Go to Solution.
Here is an interesting observation. I cannot patch to a DateTime field in my source with
Text(Now(),"[$-en-GB]yyyy/mm/dd hh:mm")
but I have a form on another screen which writes the exact same function, in Text format, to another DateTime field in my source without error.
Than you! This one works well!
User | Count |
---|---|
260 | |
110 | |
89 | |
52 | |
44 |