Issue with Date Formatting

[Anonymous]

Hello Everyone,

I am having DOB from excel and formatting it like this:

date(Date#(DOB,'DD/MMM/YYYY')) as Test,

After running it I am getting Test as a blank field..any suggestion?

Regards,

Balraj Ahlawat

[tamilarasu]

Hi Balraj,

Simply try,

Date(DOB) as Test,

[Anonymous]

again Blank

[Anonymous]

I am having one more field of Date from same excel and into same format, which is working fine

But not on this field

[amit_saini]

Try:

load *, Date(Alt(Date#(DOB, 'DD/MMM/YYYY'), Date#(DOB, 'DD/MMM/YYYY'), Date#(DOB, 'DD/MMM/YYYY')), 'DD-MM-YYYY') as Test;

Thanks,
AS

[vikasmahajan]

check your excel date format whether it is 'DD/MMM/YYYY'  becuase  date# is interpreting date check with this thread

Re: Date#() function: Worng type of output

HTH

Vikas

[Anonymous]

No luck, again blank.

If I am loading the field without any formatting, it is coming into string format...

And If I am applying any formatting, coming blank

[vikasmahajan]

can you try to change excel format -> Custom -> DD/MM/YYYY and then check

[tresesco]

Share your sample excel and let us check how exactly the DOB data is coming from there.

[vikasmahajan]

Recently I also got such issue resolved with changing format date in excel DD/MM/YYYY and appy date#