dats_from_daydate(now()) = > Current data in YYYYMMDD format
format(now(), ‘yyyymmdd’) = > Current data in YYYYMMDD format

format(longdate, string)

Date values may be used together with format strings, as described elsewhere in the NewDb documentation (look for descriptions of the TO_DATE and TO_CHAR SQL functions) . For example, format(longdate(‘2011-06-09 20:20:13.1234567’), ‘YYYY/MM/DD”T”HH24:MI:SS.FF7’)

component(date, int)

The int argument may be int the range 1..6, the values mean year, month, day, hour, minute, second, respectively. If a component is not set in the date, the component function returns a default value, 1 for the month or the day, 0 for other components. You can also apply the component function to longdate and time types.



Serkan AKKAVAK
Computer Engineer
ABAP Developer & SAP S/4 HANA Logistics Team Lead
Contact : serkurumsal@yandex.com