Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 07, 2020 04:26 AM
I have a table with a lot of webshop orders in it.
how can I make a view with all orders made to-date a year ago?
So I can compare Christmas sale from last year with the sale this year to date.
is there a function that checks for order date one year ago and back for example
Solved! Go to Solution.
Oct 07, 2020 05:40 AM
Hi Morten !
You should be able to create any date filtered view you need using two “tools” :
1) Filtered views : add two filters : start_date and end_date
2) Formula fields : use it to calculate a “virtual date” like this : DATEADD({OriginalDate}, -1, "year")
(source and list of Date/Time functions available in formulas)
Please tell me if you are able to create the view you need
Florian VERDONCK
Airtable Consultant
Oct 07, 2020 05:40 AM
Hi Morten !
You should be able to create any date filtered view you need using two “tools” :
1) Filtered views : add two filters : start_date and end_date
2) Formula fields : use it to calculate a “virtual date” like this : DATEADD({OriginalDate}, -1, "year")
(source and list of Date/Time functions available in formulas)
Please tell me if you are able to create the view you need
Florian VERDONCK
Airtable Consultant
Oct 07, 2020 05:52 AM
off course - I can set an end date 365 days from now. wow, just in front of me… thank you
Oct 07, 2020 05:54 AM
You are welcome ! :slightly_smiling_face:
Florian VERDONCK