next »

[David H.]

I have a feeling I might have mentioned this before, but just in case, please could you consider enhancing the USING operator? According to the docs https://4js.com/techdocs/genero/fgl/devel/DocRoot/User/Operators.html#OP_USING, the USING operator currently supports the number and DATE datatypes (although the purpose description suggests datetimes!).

We already have low level functions https://4js.com/techdocs/genero/fgl/devel/DocRoot/User/CExtensions.html#FMT which support DATETIME's and INTERVAL's and according to the docs also add (ww = week no) to the DATE datatype format masks.

It seems reasonable to me that it Genero (where simplicity rules right!) we should be able to use all these various formats in USING clauses directly without having to use the low level functions. I just tried ww in a DATE format and it just echoed back as ww.  Is it going to be possible to do this directly at some point in the future?

It would also be nice to have a 4GL way to convert from formatted strings to numbers/DATEs/DATETIMEs/INTERVALs using all the above formatting masks:-

    LET my_date = my_str USING "dd-mmm-yyyy"

Regards,

David

[Sebastien F.]

David,
You suggestion make sense, I have filed a new bug/enhancement for that: bz12947
Seb

[Sebastien F.]

To convert from a string to a date, we can't use the USING clause, we should rather introduce a new keyword or built-in function:

Like the SQL TO_DATE() function:

   LET my_date = TO_DATE("1998-07-07 10:24",  "%Y-%m-%d %H:%M")

Seb

[David H.]

Sounds good! I just realised I'd misread the documentation and "ww" is actually the weekday no. I would be nice if we could have an additional mask character for the week number (01-52) at some point too.

I also just noticed I posted this thread in the wrong forum section, sorry!

David