Forum Discussion
Data depending on the weekday
Hello, I want to create a report which shows data and depend on the acutal type of day (weekday). If it is monday, then show the data from friday, and if it is thuesday-friday then show the data...
why is there a difference in the date? how do you know they belong to the same transaction?
what is your purpose, can you explain the business requirement. there are several functions you can use but in order to find the best solution, i need to understand the business rule of how to join the tables to do the divide.
The data came from some web.pages,
Its general production company..
in the morning when we starting production the machine sending some signals, and we have data for new day(production tabl),
but the date from second table occured (or not) if we have some scrap in prodution and they add this manually. So the new day ocurred if the fulfill the table in web, some maybe later in the day
So i cant not interfere in this table..