# \[Solved\] Date from two column
**URL:** https://community.thunkable.com/t/solved-date-from-two-column/1659400
**Category:** Questions about Thunkable X
**Created:** [December 23, 2021, 6:05pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400 "2021-12-23T18:05:13Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 23, 2021, 6:05pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/1 "2021-12-23T18:05:13Z")
I want to retrieve the “price” data according to the “date” data which is the date from the last month. any tips?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 23, 2021, 6:36pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/2 "2021-12-23T18:36:52Z")
Please show sensible information. Your image is as good as **no image**. No one would have any interest on what price and what date, show anything but need to see the date and in what format.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 23, 2021, 7:38pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/3 "2021-12-23T19:38:58Z")
i want to get the price by date. only retrieve “price” lines that match the date. each row has a date, I want to retrieve the ones that match the date from the last month.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 23, 2021, 8:05pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/4 "2021-12-23T20:05:34Z")
See my earlier comment.
Show a table that has prices and dates.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [December 23, 2021, 8:10pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/5 "2021-12-23T20:10:29Z")
This might be helpful!
> [@Performing a VLOOKUP in LocalDB](https://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057):
>
> One of the most powerful features in Thunkable is the new [LocalDB](https://docs.thunkable.com/thunkable-cross-platform/create/components/data/local-db) component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP. question What is VLOOKUP? A [VLOOKUP](https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1), or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row art Design Let’s start…
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 23, 2021, 9:54pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/6 "2021-12-23T21:54:51Z")
i use my own table. Is it possible to get specific values from it?
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [December 23, 2021, 10:14pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/7 "2021-12-23T22:14:27Z")
Yes. Did you read the information @jared linked to?
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 24, 2021, 12:29am UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/8 "2021-12-24T00:29:11Z")
yes, and I didn’t find an answer. I’ll read it again tomorrow.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 24, 2021, 11:22am UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/9 "2021-12-24T11:22:01Z")
I have read it again and I am trying. One of the sample blocks is not in thunkable. After executing the function, it gets the last result “300” even though I specify in “if”, 11 month, not 12 month.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 24, 2021, 11:36am UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/10 "2021-12-24T11:36:22Z")
You don’t need to complicate the issue.
Try this
[https://x.thunkable.com/projectPage/61c5ae973ed5ce0010bf0a3f](https://x.thunkable.com/projectPage/61c5ae973ed5ce0010bf0a3f)
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 24, 2021, 1:57pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/11 "2021-12-24T13:57:43Z")
Okay. How else can I specify index? by not selecting it by clicking, but by selecting data from month 11.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 24, 2021, 2:15pm UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/12 "2021-12-24T14:15:46Z")
Of course there are other ways, I just updated the project to use the month as a user entry instead from the list.
Remix the project again to see the changes.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 25, 2021, 9:47am UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/13 "2021-12-25T09:47:18Z")
it all works and is very helpful to me. I am trying to download more data related to month 11 and can’t do it. I’m still learning.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 25, 2021, 10:09am UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/14 "2021-12-25T10:09:22Z")
> [@stronazyskuup](#):
>
> I am trying to download more data related to month 11 and can’t do it
You can always create a new post for the new problem that you are facing. You need to provide enough information and images of your code and sample data.
The members here are more than happy to help.
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [March 25, 2022, 10:09am UTC](https://community.thunkable.com/t/solved-date-from-two-column/1659400/15 "2022-03-25T10:09:56Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.