I am trying to use date (pulled) in current form as a validation (constraint/relevant) with some new/input date fields, but is not working. This might be because of the formats are not same. I am unable to change the format to the desired/default format that the form can understand.
Please help me to convert date in a format that i can use in present form.
@aditya, this is because the date from the CSV file is stored in the text format. You will need to convert the text format to the date format to make it a date type.
@aditya, I did a quick check but seems like the system did not support converting the date (that was in text format) to the date format from a CSV file. Maybe as a workaround, you will need to add an extra step where the user should input an exact date that is seen from the pulldata and then make calculations based on the date that you entered lately. This is an extra step but should solve your issue.
However, I also leave it to the community to see if the community should have any workarounds.
Good Afternoon @aditya@Kal_Lam@stephanealoo@Tumaini@edwinaikins if you know of any solution to this situation? I have been trying for several days to get the calculations in various ways and I have not succeeded in KoboCollect. Can you help me? Thank you in advance for your continued cooperation
The value extracted with pulldata can only be seen in KoboCollet in text format but any other calculation or action performed behaves as if the value were invisible or non-existent.