Forum Discussion
Fiscal Week Calendar Help
Hello, I want to calculate WEEKNUM but from the date I provide. Table 1: Date: 25/07/2019 Table 2: Date of Sign Up: 29/07/2019 Date of Sign Up: 02/08/2019 Date of Sign Up: 24/12/201...
Hi Anonymous ,
For those unmatched ID values of Table2, what is the default value you want to set for SentDate ?
Cheers
CheenuSing
Anonymous wrote:Hi Anonymous ,
For those unmatched ID values of Table2, what is the default value you want to set for SentDate ?
Cheers
CheenuSing
HI Anonymous , 25/07/2019
The reason why I created Table 3 is because based on the communication, I can create a column that ouputs the Date Sent and then we have Date Sign up and Date Sent in one table. I just thought maybe this method would be easier as we would not need to pass a default value.
Thanks for all your help sir.