IF Condition Date in Data Table is greater then 30 days

Help Studio
1

I’m having a hard time figuring out an If condition where a date in a DataTable is greater then 30 days. Any advice would be greatly appreciated

The image shows a workflow process in a development environment, with an error notification indicating a problem with a comparison operation between 'CurrentRow("Payment Date")' and 'AgedDate' due to type restrictions. (Captioned by AI)
The image shows a workflow process in a development environment, with an error notification indicating a problem with a comparison operation between 'CurrentRow("Payment Date")' and 'AgedDate' due to type restrictions. (Captioned by AI)960×458 22.4 KB

2

The type of CurrentRow("Payment Date") is object rather than DateTime.

Solution (see if you can figure this out yourself first)

If the column type is DateTime, you can use CurrentRow.Field(DateTime)("Payment Date") > AgedDate. If not, you can either change the column type (before data is added to the data table) or do DateTime.Parse(CurrentRow("Payment Date").ToString()) > AgedDate.

3

.Field(DateTime) is what i was missing. Thank you so much @Foxtrek_64. im going to so some reach on “Field”

I appreciate the help and education very much

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.