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

[prma7799]

PFA

[its_anandrjs]

Hi,

Use properly date functions in the Alt, If convert it into proper date num date format by using Date# then use Date to convert it into date format. See the example below from QV Help.

Ex:-

alt(

date#( dat , 'YYYY/MM/DD' ),

date#( dat , 'MM/DD/YYYY' ),

date#( dat , 'MM/DD/YY' ),

'No valid date' )

Or may be your date is not in proper date format check it.

Regards

Anand

[prma7799]

Hi Anand,

When I am using below my alt function then output is coming accept jan3 date.

Thanks

PM

[its_anandrjs]

Hi,

Try this

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

Regards,

Anand

[prma7799]

Hi ,

in this jan3 is missing and when I am using

alt(date#( F2 , 'MMM DD' ),date#( F2 , 'DD/MMM' ),date#( F2 , 'DD/MMM' ) ) as 1 ,

then jan3 is coming but it is showing me left side in list box.

Thanks

PM

[prma7799]

[Anonymous · Accepted solution]

Try this

alt(date#( F2 , 'MMM DD' ),date#( F2 , 'MMMDD' ),date#( F2 , 'DD/MMM' ),date#( F2 , 'DD/MMM' ) ) as 1

[agni_gold]

Try this , this will help you ....

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

[#10]

Hi prashantbi                  

   The Jan3 reading as text see carefully all filed having some space Month and Date but only jan3 there is no space

do one  thing give some space in source file for jan3 or else by using some qlikview function to give space

thanks

Manju