null date issue

[yadav_anil782]

Hi qlik Experts,

when i'm doing join this table in final aap with join of transection date "RECEIPT_DATE" then i's cration null date  in my qvs . what could be the resone  if there is no null date and value in source table .

LOAD

DATE([Tran Date],'DD/MM/YYYY') AS DATE,

//floor(date([Tran Date])) as RECEIPT_DATE,

date([Tran Date]) as RECEIPT_DATE,

   Payment,

     [Project name]

FROM

(qvd);

now result is  in attached

NOTE- its working fine when i'm making qvw for only this table , problem in when i'm adding in final application with all table

[kavita25]

Have you changed the date format on Main Tab?

or either post the script for better understanding.

[avinashelite]

Hi Anil,

I feel like it's a data isssue, please check the data field whether all the data are in date format are a mixture of date and text. And also cross check which join condition your using and its impact .

If you still face the issue please upload your app