Text Box validated as date

[awojciechowski]

Hello,

Next two interesting question:

1) Is it possible to validate Text Box in Interface Designer only for date e.g in this format dd/mm/YYYY - so if user will put to this box date in wrong format, App will show error information.

2) Can we combine two dates that are entered in the field text or Date ??

I have two date start and end date and I want create application which will be check and show errors if user choose start date before end date - is it possible to build this function.

e.g. of my  App. 

Thanking you in advance for your advice :)

[NicoleJohnson]

Is it possible to attach your workflow with some dummy data so we can see how these input values are being used in the workflow itself?

I do have a question about your first item - you could eliminate the need to error check for dates being in a specific format by just using a Date input instead of a Text Box input... is there a specific reason why you've chosen the text box in this case?

As for the second question, you can add an error condition that checks the logic of the start date being before the end date. See attached example. The Error Message tool will allow  you to draft an expression to check if Start Date < End Date, and then pop up an error message if condition isn't met. Note that I did use two Date input tools for this one, rather than the unstructured Text Box method.

Additional questions, please let us know!

Cheers,

NJ

[awojciechowski]

Hi @NicoleJohnson

Thanks for your answer.

Yes, it is possible but I think it doesn't make sense because my workflow is similar to yours.

Your rules using Error Message works very good :) nice to know that this kind of function is possible in Alteryx :)

In reference to your question about why I used Text Box in this case, I can told you only this - my boss want saved/minimalized interface so because i can't arrange two Date Box horizontaly, I should try to use Text Box to input this information in good format.

I hope this make sense, if you have more question, tell me.

Have you any idea how can I also make something to be sure that data in text box are put in good format and of course with the same rule as you build for Date Box?

[awojciechowski]

@NicoleJohnsonone more question, e.g. if I use yours workflow what is needed to record all the choices, so e.g. if i choose today something and tomorrow I want see in table two rows with elements selected earlier. I think it is very easy and basic question but when I use Run as Analitic App, my choices aren't save, and when i click "finish" I see this App Results.

[NicoleJohnson · Accepted solution]

@awojciechowski- no problem, I understand sometimes we are constrained by other people's requirements, so while I would certainly suggest that you try advocating again for the date boxes as a better controlled data input method, if formatting is determined to be more important to those using the app, then there are other ways you can validate the inputs.

If going the text box route, I would first recommend requiring the format to be yyyy-mm-dd instead of dd/mm/yyyy. This will make later date calculations easier if the dates start out in the right format.

For your error checking, you can basically check to see if the date format is correct in that it has 4 digits - 2 digits - 2 digits, but no really simple way to confirm that the value entered is actually a date if you're not using a date input tool. For example, 0124-85-76 would be a valid entry, even though that's not actually a date. But either way, here is the formula you can use in an error checking tool for each date input:

!REGEX_Match([#1],"\d{4}-\d{2}-\d{2}")

This will check to make sure the format of the input matches the following format (d = digit): dddd-dd-dd. The exclamation point at the beginning makes the formula inverse, so if the format does not match, then your error message will be returned.

Add one of these for each text box date input, and then use the same error message as in my original solution to check that the Start Date is prior to the End Date.

As for getting your results to show, you'll want to show the Interface Designer and pick which browse tool or output you want displayed from your workflow after your app runs. Go to View > Interface Designer, then navigate to the wrench icon on the side to see the configuration settings below that allow you to select which output you want displayed after your app runs, along with other features you can include in your app.

Let me know if that helps!

Cheers,

NJ

[awojciechowski]

@NicoleJohnson you are the best :)