How to use make date function???

[Anonymous]

Hi

I have a field called 'Paid in' which stores value 'September' in excel and now i am bringing that field into qlikview and I would like to use makedate function ,My previous developer used the function like this but

its not showing any result  and I need to know what it is trying to do .

Date#(date(Makedate(num(Year),[GS3 Paid in],1))) as OBJ_GSoS_EndDate, 

Can any one help me out this , How can I make it work.

Its a bit urgent pls

Regards,

Sharma.

[MarcoWedel · Accepted solution]

=Date#(Year&[GS3 Paid in],'YYYYMMMM') as OBJ_GSoS_EndDate,

supposed your Year is a 4 digit number.

hope this helps

regards

Marco

[Anonymous]

Hi marco,

it is showing the error , saying that field not found <year>

How shall i do that .

Regards,

Sharma.

[MarcoWedel]

your initial question suggests that there has been a Year-Field in your application.

Can you post a sample QVW to look into?

regards

Marco

[Anonymous]

Hi marco ,I dont  have a attach  file option here , Any idea?

[MarcoWedel]

Hi,

in edit mode click on "Use advanced editor" and then "Attach":

hope this helps

regards

Marco

[Anonymous]

Hi Marco,
I cant see that option at my desktop like use advanced editor. why any idea?

Regards,

Sharma.

[MarcoWedel]

No, none.

Should be there in edit mode.

Maybe the community administrators can help?

regards

Marco