Hello Vikram,
If I understand correctly, the field type is String, but it represents a Date. You want to be able to edit it as such.
1. In the input Form open the Define Data dialog (using the Right Click context menu) and add a field of type Date (letu2019s say its name is u201CDATE1u201D).
2. On the link between the input Form and the Service Open the Map Data dialog using Right Click => Map Datau2026
3. Find the relevant Field Assign in the table. Here you want to get the Date value converted into a String. From the Assign Value drop down you can choose Define Expression to open the Dynamic Expression Editor (you can skip this and write the value yourself in the Assign Value input if you know what to write).
4. On the right hand side you have model elements and functions to create an expression. You can use the function DSTR(@DATE,[format]) u2013 where parameter 1 is the Date field and parameter 2 is the Format (optional). The function returns a String representation of a given Date.
5. Your expression can look like this for example: =DSTR(@DATE1,"dd/mm/yyyy"), assuming the name of the new Date field in the Form is DATE1.
6. You can remove the old Text field from the Input Form if you donu2019t need it u2013 using the Define Data dialog.
Hope this helps,
Udi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.