I have a field on a form that is of type TEXT and holds a value of a date. For

scotte over 9 years ago

I have a field on a form that is of type TEXT and holds a value of a date. For example the user enters mm/dd/yyyy as a string. I have an Output Expression to convert this string to a DATE by using the todate() function and sent to a Target field that is a type DATE.
The problem is the Target field always contains the DD - 1 day. So if user enters 10/11/2005, then what is saved in the Target is 10/10/2005?
Why is the DD decreased by 1 day during conversion? Thanks!...

Discussion posts and replies are publicly visible

Parents

0 scotte over 9 years ago

Mike, moving on to a followup question. It appears the date we are sending to the "smart service" Query Database, which is a sub process the date that is showing with 1 DD less while we debug. It's actuall 4 hours less. The date that is entered on form is 10/11/2005 12:00AM, but in the sub process query we see it as 10/10/2005 8:00PM.... 4 hours less. Is there a setting somewhere that may be controlling time of day, etc? Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 scotte over 9 years ago

Mike, moving on to a followup question. It appears the date we are sending to the "smart service" Query Database, which is a sub process the date that is showing with 1 DD less while we debug. It's actuall 4 hours less. The date that is entered on form is 10/11/2005 12:00AM, but in the sub process query we see it as 10/10/2005 8:00PM.... 4 hours less. Is there a setting somewhere that may be controlling time of day, etc? Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data