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 Mike Cichy
Appian Employee
over 9 years ago

Scott, why not just use a date field type to capture a date?
Also, remember that dates are really datetimes in GMT in Appian engines so look through your conversion process to find where the users local GMT offset is being applied. Test it in the rules interface.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Cichy
Appian Employee
over 9 years ago

Scott, why not just use a date field type to capture a date?
Also, remember that dates are really datetimes in GMT in Appian engines so look through your conversion process to find where the users local GMT offset is being applied. Test it in the rules interface.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data