Date format

HI ,

i used this tag to select for date :<dmf:td><dmf:dateinput name="task_date" dateformat="short" />

and i am geting the control using :DateInput select_date = (DateInput) getControl("task_date", DateInput.class);

then i changed into string :String setSelectDate = select_date.getValue();

and i used that string into dql :select task_date,task_name,work_description,hours_spent from ip_timesheet where task_date>=date('"+setSelectDate+" 00:01:00','mm/dd/yyyy HH:MM:SS')";

But hear i am geting the Date Format as : Dec 23,2011 .

insted of :12/23/2011.

can please solve this issue .

Thanking you,

Rajesh.c

Find more posts tagged with

Comments

DCTM_Guru

So why dont you change the value of the date to fit your format? There is plenty of documentation on the internet to tell you how to use various date java classes to format what you need.

dm_user

In addition to what Johnny says you can achive the same in following way:

String setSelectDate = select_date.getMonth()+"/"+select_date.getDay()+"/"+select_date.getYear();

Now use the same query i.e. it will give you same result irrespective of any date format and locale settings:

select task_date,task_name,work_description,hours_spent from ip_timesheet where task_date>=date('"+setSelectDate+" 00:01:00','mm/dd/yyyy HH:MM:SS')";