Convert to number

JustynaMZ

Hi,

I am just a beginner and have faced a problem with 'tonumber'.

Can you please advise me how to convert string to the number.

I tried to use ‘tonumber’ nevertheless I probably do smth wrong as still receive data which are not treated as a nr.

Description

I have report with two dates.

I counted days from between ‘Date B’ and ‘Date A’, Result was saved in column ‘Result”

Now I need to use formula which will select only rows where ‘Result’ <=10 (I used ‘IF”).

As a records in column ‘Result’ are in incorrect format I receive false information.

Date A	Date B	Result
14.03.2020	24.03.2020	10
13.09.2020	13.10.2020	30
14.02.2020	14.02.2020	0
08.07.2020	06.07.2020	-2

Thanks for help!

Common Use Cases

Accepted answers

Qiu

@JustynaMZ
Make me wondering why your 'Result' field becomes non-numeric at first place.

If you are using DateTimeDiff, we need to change the Data Type to something 'Numeric' then it will all work out.

I am keeping your original fields for comparision.

1207-JustynaMZ.yxmd

All comments

philipmannering

Hi @JustynaMZ

You should be able to use tonumber() function (see attached). But the best way is changing the data type with the Select Tool (also attached)

Hope this helps

Phil

convert to number.yxmd

DaisukeTsuchiya

Hi @JustynaMZ .

I recommend to convert DateA and Date B into date type format then calculate Result with Number type in formula.

convert to number_DT.yxmd

Qiu

@JustynaMZ
Make me wondering why your 'Result' field becomes non-numeric at first place.

If you are using DateTimeDiff, we need to change the Data Type to something 'Numeric' then it will all work out.

I am keeping your original fields for comparision.

1207-JustynaMZ.yxmd

Tyro_abc

JustynaMZ

You can do it in two steps or one step

A: Two Steps

1) Find the difference between dates using a Formula tool

2) Filter on the difference using a Filter tool

B: Using one Step

Calculate difference between dates and use that to filter

I think you are already in the right direction but have some issue with data types.

Regards

Arundhuti

change date type.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703