Page 2 of 3

Saving Date into database not working.

Posted: Wed Mar 05, 2014 3:34 am
by frank6683668

for clarification, I have the salesforce.com date format as "mm/dd/yy" and i changed it in appery properties, still no luck


Saving Date into database not working.

Posted: Wed Mar 05, 2014 3:41 am
by Alena Prykhodko

Hello Frank,

If " /\//gi " becomes red - it's ok.

Try to test it and check browser console for errors.


Saving Date into database not working.

Posted: Wed Mar 05, 2014 3:53 am
by frank6683668

I did test it. I have date picker value mapped to request. It is still not working

"Text" works, for example: if I select input component - date, it will map it. But on mobile it is "jan" instead of "1" so I can't use it.


Saving Date into database not working.

Posted: Wed Mar 05, 2014 4:24 am
by Alena Prykhodko

Frank,

Please double check you've followed all steps described in the first reply.

If the problem persists please share your application with a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a.


Saving Date into database not working.

Posted: Thu Mar 06, 2014 5:01 am
by Milton Davis

I am having the same problem.

I am using

$("[name='getDate']").find('input').attr('id','inputgetDate');
var d = $("#inputgetDate").val();
return d;

My getDate datepicker is in the format mm/dd/yy.

How do I save to the database?


Saving Date into database not working.

Posted: Thu Mar 06, 2014 5:46 am
by Igor

Hello.

Please try next code:

pre
code
value = value.replace(/
code
value = value.replace(/\//gi, "-") + " 00:00:00.000&quot
return value;
#47;/gi, "-") + " 00:00:00.000&quot
return value;
/code
/code/pre


Saving Date into database not working.

Posted: Fri Mar 07, 2014 1:42 am
by frank6683668

No luck


Saving Date into database not working.

Posted: Fri Mar 07, 2014 2:07 am
by teneika

Hi, I had the same issue and I changed my column to a string instead of a date in the database and it worked.


Saving Date into database not working.

Posted: Fri Mar 07, 2014 2:08 am
by teneika

If you dont mind the column being a string instead of a date in the database I would change it to a string.


Saving Date into database not working.

Posted: Fri Mar 07, 2014 2:15 am
by frank6683668

Hi. Yes I did that, the main reason I want to avoid this is for reporting purposes in my database.

The issue I run into is with mobile. Example: "2" = "feb"