Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

Common answer for cases where date is loaded as a value

Hi Friends

As  per the attached data, I do not get the date loaded as value (like 48252, 48254 etc). But at some instance this happen. Mostly what I do is apply the date format as looks in the excel just under the p reloaded variables in the script such as MMM/DD/YYYY,  DD-MMM-YY etc. But the excel I worked on not this one, even if I set the format as per the excel, still the date was appeared as a value. Could you please show me what area or modification need to be done to correct this. Either in the script or otherwise

Thanks in advance

Neville

7 Replies
vishsaggi
Champion III
Champion III

Did you try like

Floor(Date(Date#(DatefieldName, 'DD-MMM-YY'), 'DD/MM/YYYY')) or

Num() function.

nevilledhamsiri
Specialist
Specialist
Author

Dear Vishwarath,

Could you please apply this in my attached data & send me the script & the expression

breno_morais
Partner
Partner

Can you attach the application?

vishsaggi
Champion III
Champion III

No source file attached can you upload please.

nevilledhamsiri
Specialist
Specialist
Author

Please refer the attachment

breno_morais
Partner
Partner

Can you explain more? I think I did not get it

Your date fields already in date formart.

nevilledhamsiri
Specialist
Specialist
Author

Yes Breno,

Attached data are ok. I have some data table in which nearly 99% are loaded with correct date format (dd-mmm-yy) but only couple of data are loaded with values such as 43452 etc.Unfortunately those set of data are missing now. Could you please show me if such cases were noted is it due to what reason & what expression orf set format to be used to overcome such cases

Thanks