DoDoTwin Posted November 9, 2016 Report Share Posted November 9, 2016 Hello, I have 5 tables with 5 different dates. If Today is between 2 of them, then I need to return a string (Status). How can i parse 5 tables and to figure out between which dates is Today and to return a string. Thanks Dorian Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted November 9, 2016 Report Share Posted November 9, 2016 Is there any connection between these 5 tables so you can join them using view? If yes then you can create the view and create a report with some CASE or JS to show the text Quote Link to comment Share on other sites More sharing options...
0 DoDoTwin Posted November 10, 2016 Author Report Share Posted November 10, 2016 Yes, all these tables are joined. Thanks for your answers (both topics) Dorian Quote Link to comment Share on other sites More sharing options...
Question
DoDoTwin
Hello,
I have 5 tables with 5 different dates.
If Today is between 2 of them, then I need to return a string (Status).
How can i parse 5 tables and to figure out between which dates is Today and to return a string.
Thanks
Dorian
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.