DatePart question

Question

I am trying to do a datepart on a time datatype field in a
mysql db and having some problems displaying the hour. For a simple
explanation of what I am trying is this:
#DatePart("h", getLastedit.eventstarttime)#
This gives: 
Parameter validation error for the DATEPART function.
The value of parameter 2, which is currently
getLastedit.eventstarttime, must be a class java.util.Date value.

According to TFM I appear to be using it correctly, unless I
cannot call the field I am wanting this way. Help anyone?

Newsgroup_User · Answer

rmorgan wrote:> > According to TFM I appear to be using it correctly,unless I cannot call the > field I am wanting this way. Help anyone?> Two things to confirm here.One, does the field getLastedite.eventstarttime contain adata value, not a string that happens to look like a date to some people?I.E. is the field in the database a date field?Two, How are you referencing your query object? Sometimes,depending on how one references the query, one also needs to provide a rowreference.This would look like this:#DatePart("h",getLastEdit.eventstarttime[1])#OR#DatePart("h",getLastEdit['eventstarttime'][1])#OR#DatePart("h",getLastEdit.eventstarttime[currentRow])#OR#DatePart("h",getLastEdit['eventstarttime'][currentRow])#Or something to that affect.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded