Forum Discussion
AlanP514
Post Patron
Post PatronGetting Blank date
Hai Guys, I am Facing An issue Please help me. I Have three tables 1. Master Data (All Employees With Distinct records),2.Salary Register Report(Employees Monthly Salary Data)3. Salary Revision Tabl...
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
PC2790
Community Champion
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.
AlanP514Post Patron
Post PatronNow 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