Date field not working properly

[kishorj1982]

Hi All,

In my data model date format is different and it is not working fine.

I have attached sample data and transformations that we used.

Could you please suggest what kind of transformations do I need to apply.

Thank

[sunny_talwar]

Would you be able to share DimContract.QVD so that we are able to run your qvw

[kishorj1982]

PFA.

Thanks

[sunny_talwar · Accepted solution]

Check the attached and see if it make sense

[kishorj1982]

Hi Sunny,

Thanks for the response.

But for end date it is not working fine.Could you please suggest on this.

Thanks

[sunny_talwar]

Have you tried applying the same logic I applied for start date for the end date