daterender in xgcolumnmodel problem NaN/NaN/NaN

[DominateQ]

If i don't multiplied by 1000 i don't get the date correctly.

Attachment 20073
I really don't know what to do and where to check what is wrong.
I told you i find this example on internet.

[issameddine]

datestamp:function(value) {
        value=value?new Date( value*1000 ).format("d-m-Y"):'N/A';
        return value; }

[issameddine]

test this function

renderDate = function (v,params,record)
{
        var dt = new Date(v);    					    
        return dt.format('d/m/Y');               
}

[DominateQ]

Here is what i get usig that function as a renderer:
img5.JPG
and without using any renderer at all:
img6.JPG

[issameddine]

you have a problem in the initial value of the date. send the json plz

[httpdotcom]

you have a problem in the initial value of the date. send the json plz

I believe I mentioned that to him earlier, and it seems to have fallen on deaf ears. His SQL shows trying to use UNIX_TIMESTAMP, but something is probably getting mucked up in localization, or that it isn't necessary in the first place.

[DominateQ]

I believe I mentioned that to him earlier, and it seems to have fallen on deaf ears. His SQL shows trying to use UNIX_TIMESTAMP, but something is probably getting mucked up in localization, or that it isn't necessary in the first place.

how/where can i find the initial value ??
I don't understand what you ask for.

[httpdotcom]

how/where can i find the initial value ??
I don't understand what you ask for.

You have a script that is producing JSON output to populate your grid. Take the output from that script and look at the date field and see why it isn't working the way you are hoping it to.

It might actually be easier to change your SQL to produce more "formatted" date information, rather than using UNIX_TIMESTAMP. Return the date, from your database, in the format you want to display it, and then rendering becomes a moot point.

[DominateQ]

Please find attached the JSON.php file archived as a zip file.
Is this what you need to check to see what is the problem ?

JSON.zip

[httpdotcom]

Is the information in that file what you see in your grid? Of course not.
You need to debug the output of

proxy: new Ext.data.HttpProxy({url: 'data.php?mode=load_form&form=incident_equip'})

to see why your date data isn't what you are expecting.