Javascript to set today's date

[swest]

I need some javascript that updates a row in a sql database with the current date. What would that code look like? Thanks!

[Davidk]

Re: Javascript to set today's date

You don't really use Javacsript to update a row in a sql database... so... not sure what you're looking for... or how you want to use it.

A current date in Javascript is...

var currDate = new Date();

This will give you a Javascript Date Object. You can then use Alpha's .toFormat() method to turn that object into a sql-friendly formatted date string... which you could then pass along.

var strCurrDate = currDate.toFormat("yyyy-MM-dd");

[swest]

Re: Javascript to set today's date

I am trying to update a sql field everytime a button is clicked with the current date. Here is the code I have, in an Inline Javascript Action, but the field is not being updated:

var rowNum = {Grid.RowNumber};
var currDate = new Date();
var strCurrDate = currDate.toFormat("yyyy-MM-dd");
{grid.Object}.setValue('G','DATEVIEWED',rowNum,strCurrDate);
{grid.Object}.submitGridPartRow(rowNum);

[Davidk]

Re: Javascript to set today's date

So much information missing... but...

You don't say "where" you button is... and now that we know it's a grid... that makes a difference. You also don't say what format you want your date in... but let's say MM/dd/yyyy.

If it's an Action Button placed on the Toolbar... then your code will be...

//place this Javascript in your code, and then reference the rowNum variable.
var rowNum = {Grid.Object}._selectedRow;
//var rowNum = {Grid.RowNumber};
var currDate = new Date();
var strCurrDate = currDate.toFormat("MM/dd/yyyy");
{grid.Object}.setValue('G','REPORTDATE',rowNum,strCurrDate);
{grid.Object}.submitGridPartRow(rowNum);

If it's a button on the grid row... then your code will be...

var rowNum = {Grid.RowNumber};
var currDate = new Date();
var strCurrDate = currDate.toFormat("MM/dd/yyyy");
{grid.Object}.setValue('G','REPORTDATE',rowNum,strCurrDate);
{grid.Object}.submitGridPartRow(rowNum);

Replace my "REPORTDATE" with your field name. Your grid is Editable... right? And out of curiousity... what SQL backend are your using... and what version/build of Alpha are you using?

Specifically... you're trying to update a Grid Control which in turn updates a SQL field.

[swest]

Re: Javascript to set today's date

Its MSSQL. It is a button on a grid row. The code for the grid row is not updating the field with the date the button was clicked. Anything else it could be within the code?

[Davidk]

Re: Javascript to set today's date

What's the data type of your MSSQL field? When you click your button, is the Grid Control updated... can you see the current date going into the control?

[swest]

Re: Javascript to set today's date

The field type is date. How would I tell if it is going into the control, do a window alert with the variable?

[Davidk]

Re: Javascript to set today's date

You've got the grid rendered... with your DateViewed control visible?

[swest]

Re: Javascript to set today's date

I have the DateViewed control in the selected part of the grid component but I am hiding the field as I dont want the user to see it.

[Davidk]

Re: Javascript to set today's date

And the editable checkbox is checked... right? If you were to unhide the DateViewed field... can you change the value in that field using it's dropdown... and then save that value?

In the Query section, is it checked Read only?

Can you edit other fields in the grid and save them?

[swest]

Re: Javascript to set today's date

Yes, when I unhid the dateviewed field and changed the date and clicked the button, it did change the date in the database field.

[Davidk]

Re: Javascript to set today's date

I don't think any more guessing is going to help. You'd have to post your Grid and a sample table.

[swest]

Re: Javascript to set today's date

This might help when I window.alert(strCurrDate); it outputs 43m/14/2017. Maybe the 43m is formatted wrong in the code?

[Davidk]

Re: Javascript to set today's date

Yes... somethings not right. The only way I can duplicate that is with a wrong date mask...

e.g. "mm/dd/yyyy" will output the current minute plus the rest of the date... e.g. my time is now 7:12pm... so I get 12m/14/2017.

Your mask must be "MM/dd/yyyy". MM is the month number... m is minutes.

And... you don't need window.alert.. alert by itself will do.

[swest]

Re: Javascript to set today's date

Its working, thanks for your help!