# How to compare two distinct types of columns
**URL:** https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465
**Category:** Ask for Help
**Created:** [September 18, 2024, 5:41am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465 "2024-09-18T05:41:10Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@BrianWyne](https://community.glideapps.com/u/BrianWyne)
#### Post date: [September 18, 2024, 5:41am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/1 "2024-09-18T05:41:10Z")
I am building an app to help bus operators track their time and pay rates.
The rules for raises are, step1, 70% of the Toprate for the first year, step 2, 80% for the next year, step 3, 90% for the next 6 months, step 4, 95% for the next 6 months, then step 5, full pay. The start date is different for everybody, and some users are already partially through the raises. I have a separate column for what their current step is 1, 2, 3, 4, 5. I would like to fill in the rest of the dates so that their pay for each day is paid based on if the date for the work is within each step date.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 18, 2024, 10:55pm UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/2 "2024-09-18T22:55:49Z")
How does your top rate change? Or is it fixed?
---
### Author:  [@BrianWyne](https://community.glideapps.com/u/BrianWyne)
#### Post date: [September 23, 2024, 4:14am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/3 "2024-09-23T04:14:53Z")
The top rate changes year to year based on our contract. For example, there is a new top rate coming that is a 4% raise on the previous top rate. More to my point is determining the step raises from the user’s current rate and their step entry date. The formula for the steps is described above.
If the users pay step is 1 then step 2 is 1 year later, step 3 another year later, step 4 six months later and finally step 5 six months later.
I would like the dates to be dynamic so I can use them in my work table that has the users work by date and time.
---
### Author:  [@BrianWyne](https://community.glideapps.com/u/BrianWyne)
#### Post date: [September 25, 2024, 7:46pm UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/4 "2024-09-25T19:46:23Z")
For the Steps Step 1 is 70% of the top rate, 2 is 80%, 3 is 90%, 4 is 95% and finally 5 is 100%
I would like for the work data to have a separate rate number and top rate so that if they work one day at step 2 and the next day get step 3, I don’t want all the previous work to suddenly be calculated at step 3.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 26, 2024, 12:16am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/5 "2024-09-26T00:16:04Z")
So circling back to your original post, you have a start date for everybody, and now you just need to calculate the dates where next steps start?
> [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15):
>
> Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) To get the leap year date of Feb 29th to back date to Feb …
Adapting this formula from @Jeff_Hager .
```auto
((Now-DAY(Now)+15)+(Years*365.25))
-
DAY((Now-DAY(Now)+15)+(Years*365.25))
+
DAY(Now)
```
With Now being the Start Date, Years being:
1 for Step 2
2 for Step 3
2.5 for Step 4
3 for Step 5
---
### Author:  [@BrianWyne](https://community.glideapps.com/u/BrianWyne)
#### Post date: [October 19, 2024, 6:18am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/6 "2024-10-19T06:18:48Z")
The Step dates are more complicated than I previously understood. Therefore, I am asking the operator to enter their own step dates personally.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [July 23, 2025, 4:15am UTC](https://community.glideapps.com/t/how-to-compare-two-distinct-types-of-columns/76465/7 "2025-07-23T04:15:07Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.