About "today" and "datenow"

[Former Member]

Hello, there!

Do you know how exactly how "today" and "datenow" built-in functions work?

I doesn't matter how I configure my date formats, it always seen to return on

'YYYY-MM-DDTHH:MI:SS' format, so I always have to format it again to fit on my date formats.

Is there a better way to work with those functions? Am I missing something?

Thanks in advance!

[Former Member]

Hi,

In BLS 'today' always give the date in 'YYYY-MM-DDT00:00:00' format and datenow will give the date in 'YYYY-MM-DDTHH:MI:SS' format only.

If you want to change some other format, then you need to use 'datefromxmlformat( datetime, toformat )' in your BLS.

Thanks,

Manisha

[former_member192939]

The datenow standard format is 'YYYY-MM-DDTHH:MI:SS'.

I suggest the same as Christians post.

Good luck,

Ajay.

[jcgood25]

Ajay - Please watch the accuracy of your posts, some of the DateFormat letters are quite different when using upper or lower case:

http://help.sap.com/saphelp_xmii115/helpdata/en/popups/DateFormatPopup.htm

"yyyy-MM-dd'T'HH:mm:ss" is actually the format of the XML datetime you'll see in BLS and the default XML output of MII.

You will not see the single quotes in the output of a date string in native format, but these indicate for the formatting that the capital letter T is merely text in between the two halves.

Regards,

Jeremy

[former_member192939]

Hey Jeremy,

I remember that, sorry for the upper and lower case of the text.

I was in a hurry and did copy and paste the format from the above post.

Thanks for correcting

Ajay.

[Former Member]

Yea, it returns in xml format.

datefromxmlformat( datenow,"yyyy" )

seems the easiest way to format.