Skip to main content

Hello, I have a JF table which contains dates of public holidays and an APPRO table which contains a date field. I can't test if the date field in the APPRO table is a public holiday. Does anyone have a solution?

EDITED: Ignore this, ​@Alexey_Gusev ‘s solution below is much better

Hmm, I think you’re going to need to link all of your public holiday records to each of the records in APPRO, and then use a formula field to check whether it’s the same date.  I’ve set it up here for you to check out

IF(
  FIND(
    {Date formatted},
    {Date formatted (from Public Holidays)} & ''
  ),
  'True',
  'False'
)

 

ok thank you very much

Note that a bit easier way is to make Date formatted a primary field in “Holidays” and then in APPRO just clean linked field, copy-paste ‘Data Formatted” in it and that’s all - records with links are holidays.

Oooh yeah, you’re right, that’s a lot cleaner and I’ve set it up here

Hello, I did this in the end, thank you

Reply


Terms & Conditions