Help With Error: Parse Error at char(19): Invalid type in operator >. (Expression #2)

[Leanna12]

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?

[BS_THE_ANALYST]

@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:

[alexnajm · Accepted solution]

Based on the error, either one of your [Date] fields is not being stored as a Date data type!

[Leanna12]

Thanks for this! Do you have some recommended solutions to correct the date format?

[BS_THE_ANALYST]

@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.