incorrect date format qlikview script

[capriconuser]

i have this script 

file_Mapping:

MAPPING 
LOAD
     Policy_No., 
     date(floor(Policy_Effective_Date_Update)) as
Policy_Effective_Date_Update 
    
FROM
[Mapping_ffile.xlsx]
(ooxml, embedded labels, table is [Mapping_ffile]);

and 

file_Mapping:
LOAD  
     [Policy #],      
     date(Floor(ApplyMap('PSD_Mapping',[Policy #]))) as date_test,
FROM
Member_file_test.qvd
(qvd);

so when i check date_Test file this shows incorrect format like below image 

[dplr-rn]

You may need to format is after you floor it. using Date function

Also i would double check the format the format of the timestamp from excel. Load it directly into a table without floor and check the format and data type you are getting

[capriconuser]

i did all that but nothing helps i chnage the format of date in properties and also in excel but sam thing appears

[jonathandienst]

What is the format of the date field in the source Excel file?

[capriconuser]

DD-MMM-YYYY

[ChennaiahNallani]

file_Mapping:

MAPPING 
LOAD
     Policy_No., 
     date(date#(floor(Policy_Effective_Date_Update),'dd-mmm-yyyy'),'dd-mmm-yyyy') as
Policy_Effective_Date_Update 
    
FROM
[Mapping_ffile.xlsx]
(ooxml, embedded labels, table is [Mapping_ffile]);

[capriconuser]

this shows an error 

MAPPING requires 2-column input

[Brett_Bleess]

Couple of Design Blog posts that may be of some use to check your logic etc.

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-as-an-Alternative-to-Joining/ba-p/1473454

You can use the following link to search yourself in this area as well:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett