Common answer for cases where date is loaded as a value

[nevilledhamsiri]

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

[vishsaggi]

Did you try like

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

Num() function.

[nevilledhamsiri]

Dear Vishwarath,

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

[breno_morais]

Can you attach the application?

[vishsaggi]

No source file attached can you upload please.

[nevilledhamsiri]

Please refer the attachment

[breno_morais]

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

Your date fields already in date formart.

[nevilledhamsiri]

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