Forum Discussion
Post PatronGetting Blank date
Now the issue is solved Because my calendar is having more dates but in salary only having up to April so I created a variable from todate and today. now it is working, thank you
Post PatronYes in the calendar table I have data beyond march 2022, Could you help me
Community ChampionThere could be numeeous reasons for this.
1) Could be the relationship, try to make the relationship as active with Calendar to all other tables
2) Check the April data in your Salary Registrar Table,could be that the syntax is not same as that of calendar table.
If you can share your sample file removing sensitive data, I can take a look.
- AlanP514
Now the issue is solved Because my calendar is having more dates but in salary only having up to April so I created a variable from todate and today. now it is working, thank you