Dear Forum,
I am having problems on the use of Date type fields.
Since Dates are stored as plain text values in the database I am not able to do proper sorting and applying (SQL) queries on date values.
Think of "select all dates between now and next week" or "show all records with a date earlier than a specific date".
Dates are sorted alphabetically and not in date/time order.
I saw in the forum several questions on this matter which have never been answered.
I need functionality such as:
Creating lists ordered on due date, lists with activities within a specific date range.
This is not simply a matter of standard filters on data lists, but requires dedicated SQL querying.
One could think of a solution to store everything in format yyyy/MM/dd. Than alpabetical sorting comes near time sorting.
However the Joget workflow deadline checking functionality requires a specific format dd/MM/yyyy. So to be able to use the deadline checking I am restricted to that format.
And the users also like to have their favorite representation.
Is any solution possible here?
I cannot imagine this has not been solved before.
Regards,
Joost van der Schoot