You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

  • No labels