[DM_QUERY_E_DATE_FORMAT]error

samp577

Hi everyone,

I am using Forms Builder 6.6,

we are having a requirenment which should give the difference of the two date values selected by the user in the date fields in a text box, as shown in the below screen shot.

 

i used a global adaptor to solve this issue, i took the dql like shown below.

select DATEDIFF(day,DATE('Dec 12,2011','dow mon dd hh:mm:ssTZD yyyy'),DATE('Dec 14,2011','dow mon dd hh:mm:ssTZD yyyy'))

as diff from lma_details

and i tryed the different date formats also,

i took the two input values like start date and end date, and took the output type item as diff of string type because my Total Leaves is a String type. i tryed with integer type also.

finnaly the adaptor is valid whether we take integer or String and with out date format or with any date format.

my problem is in task space we get a error msg as shown below.

by defalt values it shown the error msg like

while passing date values manually it shows the error msg like

Is there any literal to specify time zone in DQl.

Please help me out to solve this issue.

Thanks in advance....

Regards,

Sampath A

DCTM_Guru

Is the start date and end date in different time zones?  If not, then you dont have to worry about putting the time zone in since the calculation is going to be in that time zone.  Also, keep in mind that Content Server actually stores the date in GMT.