Hello everyone
I have two input fields, one for 'Retest Date' with a text data type, and another for 'Manufacturing Date' with a date data type. My user enters a value of '2 years' in the 'Retest Date' field and a manufacturing date of '27-08-2024' in the 'Manufacturing Date' field. I need to calculate the date that is 2 years from the entered manufacturing date and display it in the 'New Retest Date' field. How can I achieve this?"
hello @Male Navitha
Refer this link:
https://www.outsystems.com/forums/discussion/81626/text-to-date-with-different-format/#:~:text=Split%20the%20Date%20text%20value,to%20Date%20data%20type%20value
I hope this helps
Thanks
Hi Male,
you can just use the following function
AddYears((Yourmanufacture Date Variable),TextToInteger(retest variable))
this should solve your problem.Thanks Narendra Tiwari
If it's really free text you are allowing in the "retest date" field, you need to write a parser for that. And that's not something I'd advise you, and neither is it specific to OutSystems.
Hi @Male Navitha ,
In addition to what Killian have already pointed out, I would suggest that you change the free text into something else, probably an integer field with label "Retest Date (in years)" or months or days depending on the usual frequency. You can even customize it depending on the requirements. Allowing it to be free text means they can input anything, even "2 decades", or maybe even "2 fortnights, 7 and a half days, 13.56 hours". Creating a parser for that will be quite a headache.
So it would really be very easy if you would make it more simple. If your input is just integer, then you'll just have to use AddYears(ManufacturingDate, RetestDate) and assign it to your New Retest Date field.
There are other simple ways as well to do this and I hope you don't sweat too much on making it complicated.
Regards,
Bryan