axtech
going with the flow
Posts:35
 |
| 08-25-2009 06:14 AM |
|
I am using Date as a question type and Date display type is Textbox w / Calendar. I can see the selected date in the textbox from the calendar but when i submit the form then date is stored for one day earlier. e.g i selected 25/08/2009 from the calendar but in the backend it is storing as 24/08/2009 23:00:00.
I am using 02.70.53 version of dynamic forms. I hope there is a solution for this.
Thanks in Advance |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-25-2009 06:34 AM |
|
HI, this is how SQL functions. When you select a date from the textbox calendar field, you are only picking the "date" part. However, when the data is stored in the backend, it's using SQL "datetime" datatype, which would append the time of submittal to the date. In SQL, there's a "datetime" and "smalldatetime" datatype, and a "timestamp" datatype, but no actual "date" only datatype. So if you want to query only yesterday's date, you would need an SQL query like this:
select * from tablename where datecolumn between '08/25/2009' and '08/25/2009 23:59:59'
Hope this anwers your question. -- David |
|
|
|
|
axtech
going with the flow
Posts:35
|
| 08-25-2009 06:41 AM |
|
Hi David
Thanks for the quick response but the issue is not with the time, the issue is that it stores yesterdays date what ever date I select. It should store the date what i select from the calendar not one day before. I hope it explains better. |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-25-2009 06:45 AM |
|
Okay, now I understand but this doesn't make sense unless your DNN clock is one day behind. Can you check your DNN website time? Go to Host / Host Settings and see what the "Server Time" is set to. -- David |
|
|
|
|
axtech
going with the flow
Posts:35
|
| 08-25-2009 07:01 AM |
|
I have seen it and it seems ok, you can see the time below
Server Time : 25/08/2009 17:00:38 |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-25-2009 07:12 AM |
|
Okay, can you go to HOST / SQL and type in:
select getdate()
and verify what it's returning. Also, on your DF form completion event, do you have any SQL statements that you are executing? -- David |
|
|
|
|
axtech
going with the flow
Posts:35
|
| 08-25-2009 07:29 AM |
|
when i run this querry it prints 25/08/2009 17:28:10 and i am not running any sql statement at the form completion i am sending a dynamic email which emails the content what ever is filled in the form. |
|
|
|
|
David To
river guide
Posts:2719
|
| 08-25-2009 07:42 AM |
|
So in your email event, if you send an email to yourself with the calendar token included, are you getting the datetime as one day before? I'm I correct in this? Can you export your form to www.betasprings.com (username: host, password: dnnhost) and tell us the URL/tabID so we can take a look at this strange, bizarre issue? I know the one on betasprings is the more current version but 2.70.53 shouldn't have had this problem. Thanks. -- David |
|
|
|
|
Hajo Emch
going with the flow
Posts:30
|
| 10-08-2009 03:39 AM |
|
Hi
I have the same issue. Its always a day before! It does nothing has to do with the server time!
What could it be?
Thanks for help
Hajo |
|
|
|
|
David To
river guide
Posts:2719
|
| 10-08-2009 06:38 AM |
|
HI Hajo, what version of DNN and DF are you running? Can you duplicate this on www.betasprings.com also? Is this an email event or an SQL event that you are saving to a table? -- David |
|
|
|
|
Candace
river guide
Posts:2431
|
|
Hajo Emch
going with the flow
Posts:30
|
| 05-04-2010 11:38 PM |
|
Hi
I still have the problem. If the user enters 01.05.2010 it ends up in 30.4.2010 22:00. That means, that there is a difference of 2 hours.
What kind of transformations are you doeing in code? Maybe casting to datetime? That could help me to analyse the problem.
Thanks Hajo |
|
|
|
|
David To
river guide
Posts:2719
|
| 05-05-2010 07:51 AM |
|
HI Hajo, I don't get it. You say there's a difference of two hours but 01/05/2010 is way different from 30/4/2010 22:00.
What language are you using on your site? Also, is this a textbox field or a date field type? Can you export your form to www.betasprings.com (username: host, password: dnnhost) and see if this can be duplicated on betasprings as well? Another words, after submitting the form, can you go to Advance Features / View Form Results and see if this can be duplicated? -- David |
|
|
|
|
Hajo Emch
going with the flow
Posts:30
|
| 05-05-2010 09:43 PM |
|
Hi Chad
no in dd.mm.yyyy format 01.05.2010 and 30.4.2010 22:00 is very near. It must have to do with some settings. I use a normal datefield.
I solve the problem for me now in adding two hours to the date.
thanks
Hajo |
|
|
|
|