# Columm Math / IF Then Else **URL:** \ **Category:** Report a Bug\ **Created:** [February 24, 2021, 1:30am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321 "2021-02-24T01:30:46Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Buda\_Queobariu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/buda_queobariu/32/5351_2.png) [@Buda\_Queobariu](https://community.glideapps.com/u/Buda_Queobariu)\ **Post date:** [February 24, 2021, 1:30am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/1 "2021-02-24T01:30:46Z")
Greetings from Brazil, Dear, I have a problem and I think it is a Bug, The column is MATH recognized as Date, it is not recognized as Date when I try to use “IF Then Else” below photo for example: My app’s URL: [https://fabiomotaortodontia.glideapp.io/](https://fabiomotaortodontia.glideapp.io/) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b530bf2fa48a24154101b6f9114e6724c7d9582b.jpeg) It is necessary to use the IF Then Else to compare the Dates. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 24, 2021, 1:45am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/2 "2021-02-24T01:45:22Z")
What’s your configuration for IF\_Data Ajustada…? ---
**Author:** ![Buda\_Queobariu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/buda_queobariu/32/5351_2.png) [@Buda\_Queobariu](https://community.glideapps.com/u/Buda_Queobariu)\ **Post date:** [February 24, 2021, 2:14am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/3 "2021-02-24T02:14:09Z")
Thank you for responding promptly … ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d31df9ae53be29a4c501cb24861befcd72adb44f.jpeg) ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [February 24, 2021, 2:23am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/4 "2021-02-24T02:23:05Z")
Hola Buda, I think your problem began from > _TEMP\_Datas Parcelas_ which is not a native Date column, it’s a Template instead. So, Glide treats that column as a Text. Saludos ---
**Author:** ![Buda\_Queobariu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/buda_queobariu/32/5351_2.png) [@Buda\_Queobariu](https://community.glideapps.com/u/Buda_Queobariu)\ **Post date:** [February 24, 2021, 2:32am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/5 "2021-02-24T02:32:35Z")
I did the decomposition of Data using Math column, separated the day, month, and year. After that I made this column TEM\_Datas Parcelas, to recompose the date format. I used If to filter and math (which recognized the date format), so I think it is a bug because, in the MAT\_Data Adjusted column is as a date and when trying to filter with If it no longer recognizes as a date … if MAT\_Data Adjusted not having a date all right it was no problem @Jeff_Hager , @ThinhDinh … is bug? Saludos ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 24, 2021, 11:24pm UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/6 "2021-02-24T23:24:19Z")
At the part where you decompose the data using math and rejoin them again using a template column, can you show us the math column that “recognizes the date format”? I don’t think it can recognize. ---
**Author:** ![Buda\_Queobariu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/buda_queobariu/32/5351_2.png) [@Buda\_Queobariu](https://community.glideapps.com/u/Buda_Queobariu)\ **Post date:** [February 25, 2021, 12:22am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/7 "2021-02-25T00:22:18Z")
![IMG_20210223_202525_461](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3fa345359d865e1ac69bcbf4d167f8a8fabb18ea.jpeg) Here ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 25, 2021, 12:52am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/8 "2021-02-25T00:52:04Z")
Seems like you’re pointing that DATE value to an If Then Else column, not a template one, isn’t it? ---
**Author:** ![Buda\_Queobariu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/buda_queobariu/32/5351_2.png) [@Buda\_Queobariu](https://community.glideapps.com/u/Buda_Queobariu)\ **Post date:** [February 25, 2021, 1:13am UTC](https://community.glideapps.com/t/columm-math-if-then-else/23321/9 "2021-02-25T01:13:44Z")
Yes, I used math to decompose day, month and year. after I used a template to recompose the date using the correct day. filtered by If Then Else and used Math again for Glide to recognize it as a date.