I have two tables:
Invoices
Time
Invoices has a project, start date and end date.
Time has a project, start date and hours.
I’m trying to find all the time records between the Invoice start and end dates for a project and assign them to the invoice. But when I try to find the time AT only allows static choices, not dynamic. How can I make this work?
Best answer by TheTimeSavingCo
Ah to do this you can try creating helper fields that convert your Date fields into milliseconds using the following, which you can then set up in your Find Record action:
+32Ah to do this you can try creating helper fields that convert your Date fields into milliseconds using the following, which you can then set up in your Find Record action:
Your using a “Projects” table instead of an invoice table, but I guess it’s the same difference.
But in your formula: DATETIME_FORMAT(Start, 'x') + 0
What does + 0 do?
+32Ah the +0 converts it to a number so that the Find Record step allows us to use >=, <= etc. If we don’t do that then it’s considered text, and the Find Record step will only allow us to use ‘contains’, ‘is’ etc
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
