Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago
Solved

Getting 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...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AlanP514's avatar
    AlanP514
    4 years ago

    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's avatar
PC2790
Community Champion
4 years ago

Hey AlanP514 ,

 

Can you check once if you have dates beyond March 2022 in your calendar table?

Also,Is there any specific reason that the relationship with the Calendar table from Salary Register is inactive?

 

Thanks 

AlanP514's avatar
AlanP514
Post Patron
4 years ago

Yes in the calendar table I have data beyond march 2022, Could you help me

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    There 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's avatar
      AlanP514
      Post Patron
      4 years ago

      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