Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Passing the data interval to a text field

Hello, I want to send date in text format from 2 calendar objects into a date interval textfield e.g. "20090720:20090724".

How can I achieve this?

Thanks,

MD

Former Member replied

Hi,

In order to pass a date range in the text format you can use the following procedure.

1. Let us say your calendar objects are "From" and "To".

2. Create a data store and include a field "DateRange"(Text field), connect this data store to the output of your form and select event as submit.

3. In the submit event write the formula suggested by Margaret Hilsbos or "DSTR(@from,"MM/DD/YYYY")&":"&DSTR(@to,"MM/DD/YYYY")" this is just another date format.

4. now you can use the value in the data store(STORE@DateRange) to feed your data service, query etc... this will be a text value.

hope this helps,

Rk.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question