# Automatic feed of holiday dates **URL:** \ **Category:** Ask for Help\ **Created:** [February 20, 2023, 2:46am UTC](https://community.glideapps.com/t/automatic-feed-of-holiday-dates/58182 "2023-02-20T02:46:16Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![james](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james/32/71213_2.png) [@james](https://community.glideapps.com/u/james)\ **Post date:** [February 20, 2023, 2:46am UTC](https://community.glideapps.com/t/automatic-feed-of-holiday-dates/58182/1 "2023-02-20T02:46:16Z")
Hey guys, I am looking for a way to automatically pull in public holidays for the current and next calendar year. In my case, this is for Western Australia. Once in Glide they will be used to filter out dates that field staff can be booked for jobs. Has anyone done this before? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 20, 2023, 2:53am UTC](https://community.glideapps.com/t/automatic-feed-of-holiday-dates/58182/2 "2023-02-20T02:53:02Z")
Yes, but not automatically. I have a Staff Leave App that accounts for Public Holidays when Staff apply for leave, to calculate the correct number of days to deduct. But Public Holiday dates rarely change, so I haven’t bothered trying to auto-import them. I just manually enter them into a table at the start of each year. ![CleanShot 2023-02-20 at 10.51.59@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/174af06dd5eb3f7ad5d1f96efd229cfaabc295e5.jpeg) ---
**Author:** ![james](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james/32/71213_2.png) [@james](https://community.glideapps.com/u/james)\ **Post date:** [February 20, 2023, 3:07am UTC](https://community.glideapps.com/t/automatic-feed-of-holiday-dates/58182/3 "2023-02-20T03:07:35Z")
I am currently doing them manually but find that there are a couple of cases where the date may change for booking purposes. - Easter seems to always be different - When the day falls on a weekend and it is taken as a day in lieu during the standard working week ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 20, 2023, 3:20am UTC](https://community.glideapps.com/t/automatic-feed-of-holiday-dates/58182/4 "2023-02-20T03:20:08Z")
Do you include the Year? That’s what I do - so Good Friday 2022 and Good Friday 2023 are two _separate_ rows in my table. Doing it this way, it doesn’t matter if the dates change from year to year (which they always do). ---
**Author:** ![james](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james/32/71213_2.png) [@james](https://community.glideapps.com/u/james)\ **Post date:** [February 20, 2023, 4:01am UTC](https://community.glideapps.com/t/automatic-feed-of-holiday-dates/58182/5 "2023-02-20T04:01:05Z")
Yep, we include the year. Was just thinking about a set and forget alternative to manually putting them in, not that it takes a heap of time. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 20, 2023, 5:14am UTC](https://community.glideapps.com/t/automatic-feed-of-holiday-dates/58182/6 "2023-02-20T05:14:37Z")
I guess if you could find an API it would be doable. But personally, I don’t think it would be worth the effort.