Changing a date function in a Oracle pull

I know it has something to do with the date, but I am not sure how to rewrite.  I tried the second one and still have issue.

 

Any help would be greate

 

SQL

'                               strSQLEntLoad = strSQLEntLoad & "Where vData.CatKey= " & API.POVMgr.fCategoryKey(API.POVMgr.PPOVCategory) & " And vData.PeriodKey= '" & API.POVMgr.fPeriodKey(API.POVMgr.PPOVPeriod).strDateKey & "' AND vData.PartitionKey=" & API.POVMgr.fCheckLocProf(API.POVMgr.PPOVLocation).lngLocKey & ";"

 

This is the error with the first one.  It is only an error with the date

ERROR:
Code............................................. -2147467259
Description...................................... ORA-00911: invalid character
Select Distinct vData.EntityX FROM vData Where vData.CatKey= 15 And vData.PeriodKey= N'20121031' AND vData.PartitionKey=794;