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?
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,