Help With Error: Parse Error at char(19): Invalid type in operator >. (Expression #2)
Here is the Syntax...
DateTimeDiff([Column 1 Date],[Column 2 Date],"days")
Any ideas how to troubleshoot this?
Solved! Go to Solution.
@Leanna12 Check [Column 1 Date] or [Column 2 Date]. One of them isn't formatted as a Date. You need to convert one of those (or both if neither are formatted as a date) using the DateTime tool:
Based on the error, either one of your [Date] fields is not being stored as a Date data type!
Thanks for this! Do you have some recommended solutions to correct the date format?
@Leanna12 depends on how the date actually looks. As I previously mentioned, I would use the DateTime tool.
Open the tool palette, select the DateTime tool, you can find this in the Parse section.
Click on Open Example, this page pops up:
Run the workflow, then move down to example convert a String to a Date:
You can see how they converted the DOB column from a string to a Date (see the DOB_New column on the end).
If your date matches none of the presets, check the Convert a Custom Formatted String to a Date example which is further down the example page.