Date is missing

[prma7799]

Hi All,

When i am using (alt(Date#(F2,'MMM DD'),Date(F2,'DD MMM')) as Date)

then my one date is missing.

Can anybody tell me where i was wrong in ALT function

Thanks
PM

[PrashantSangle]

Hi,

Try like

alt(Date#(F2,'MMM DD'),

Date(F2,'DD MMM'),

Date#(F2,'MMMD'),

Date(F2,'MMMD')

) as Date

Regards

[tamilarasu]

Hi Prashantbi,

Jan3 is not a valid format. Just give space between date and month. i.e jan 3.

Below solution works for your data.. Just try this.

alt(Date#(F2,'MMM DD'),Date#(F2,'DD MMM'),Date#( F2 , 'MMMDD' ))

[agni_gold]

Date#

(trim(Left(F2,3))&' '& trim(Mid(F2,4,3)),'MMM DD') as

Date_123

you can also try this

[jonathandienst]

Hi

You have 3 different date formats, so you need 3 parts to your Alt():

Date(alt(Date#(F2,'MMM DD'), Date(F2,'DD MMM'), Date#(F2,'MMMDD'))) as Date

[agni_gold]

[prma7799]

Hi Greeshma,

No need to write above full expression I used only

alt(date#( F2 , 'MMM DD' ),date#( F2 , 'MMMDD' )), 'MM/DD/')  function