pulling a date field from a spreadsheet

[#1]

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]

Hello,

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

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

Hope that helps

[tresesco]

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

[#4]

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

I placed it in the sql statement

[Miguel_Angel_Baeyens]

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.