In CRMScript I'm trying to find all companies where my UserDefinedField (date) is in a certain timeframe. From what it seems, dates are stored in the UDXXXsmall table as Longs [1], so im thinking i somehow have to do something with the userdef_id (FK udcontactSmall) table of my contact table [2]. However, when trying a few of the "Long" values, i get just long numbers, and not the date values im after.
I've set the UserDefinedField as Indexed, and tried all long01-04, but there are just numbers which i dont understand what to do with.
I can't make sense of how to get the actual values, and would appreciate some help, please let me know if more information is needed 😊
[1] https://docs.superoffice.com/en/custom-objects/reference/index.html
[2] https://docs.superoffice.com/en/database/tables/contact.html