Skip to Content (Press Enter)
UserImage.jpg
PJ M
922Views
4Comments
Solved
How do I tell if the user input a Date, Int, Float, or TEXT?
Question

I have a text field and I need to know if the value the user entered into the field is a Date or a number or not.

How do I do that in outsystems?

SQL Server has isNumeric(@input) and isDate(@input), but this doesn't fly in an aggregate

SyntaxEditor Code Snippet

Search.DataType="VARCHAR" or (isnumeric(SearchString) and Search.DataType="INT")  or (isdate(SearchString) and Search.DataType="DATE")

What will fly?

0
0
11 Jan 2019
Copy Link
2018-12-09 19-13-19
Tiago Gomes
Solution

Hello,

Maybe for your case you can use built-in functions like TextToDateTimeValidate(Text) / TextToDateValidate(Text) and TextToIntegerValidate(Text), just to know if you're getting what you pretend check here the built-in functions available. Another solution, already presented on the comment above is using regex for what you pretend.

I hope you find this useful,

Tiago

See solution in context
0
0
11 Jan 2019
Copy Link
2018-12-09 19-13-19
Tiago Gomes
Solution

Hello,

Maybe for your case you can use built-in functions like TextToDateTimeValidate(Text) / TextToDateValidate(Text) and TextToIntegerValidate(Text), just to know if you're getting what you pretend check here the built-in functions available. Another solution, already presented on the comment above is using regex for what you pretend.

I hope you find this useful,

Tiago

0
0
11 Jan 2019
Copy Link
UserImage.jpg
PJ M

Thank you, yes, the TextToDateValidate and TextToIntegerValidate are the functions I was looking for, so I marked that as the solution. In the meantime, I converted my aggregate to an Advanced SQL like this, in case it helps anyone else later...

SyntaxEditor Code Snippet

SELECT {Search}.* from {Search} where
{Search}.DataType='VARCHAR' or (isnumeric(@SearchString)=1 and {Search}.DataType='INT')  or (isdate(@SearchString)=1 and {Search}.DataType='DATE')
0
0
12 Jan 2019
Copy Link
UserImage.jpg
da vet1986

You can try to use regular expressions


https://cambosports24.com

0
1
12 Jan 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.