topic pulling a date field from a spreadsheet in QlikView

pulling a date field from a spreadsheet

Wed, 16 Mar 2011 18:50:24 GMT

My transdate field looks like this...01/30/2011.

How do I convert this so I can use it as a date range (i.e. if transdate >= 1/30/11 and transdate <= 2/26/11, feb-01, etc...etc

thank you

New to the Q

Miguel_Angel_Baeyens — Wed, 16 Mar 2011 18:52:49 GMT

Hello,

If that is the correct date format, go to the script editor and try

Date(transdate, 'MMM-YY') AS DateRange

Hope that helps

tresB — Wed, 16 Mar 2011 18:57:44 GMT

if you don't need to deal with your own range, you can use function - MONTHNAME. have a look at it. if this does not solve your problem, let us know.

Regards, tresesco

Wed, 16 Mar 2011 19:00:10 GMT

Date' is not a recognized built-in function name.

I placed it in the sql statement

Miguel_Angel_Baeyens — Wed, 16 Mar 2011 19:05:20 GMT

Yep, the right place to set it is the LOAD part (that I use all the time, and I strongly recommend you to do as well):

LOAD Date(transdate, 'MMM-YY') AS transdate;SQL SELECT transdateFROM Database.table

Hope that helps.