Hello!
I'm trying to add a formula that will compare whatever the current date is to a date field. However the date field is just a string/text value.
the date field is stored like this 20230914 and it's just recognized as text so I need it to be a date like this 9-14-2023
I've tried format([date field],"mm-dd-yyyy") >date() but I get an overflow error
I know the answer is simple but just can't figure out what it should be.
I'm trying to add a formula that will compare whatever the current date is to a date field. However the date field is just a string/text value.
the date field is stored like this 20230914 and it's just recognized as text so I need it to be a date like this 9-14-2023
I've tried format([date field],"mm-dd-yyyy") >date() but I get an overflow error
I know the answer is simple but just can't figure out what it should be.
