Initial value for date w/ clientSideDateFormat

[Steve Workings]

I'm implementing a site that uses session.__protected__clientSideDateFormat to provide the correct date format (duh).

But the implementation doesn't seem to affect an initial value.

So, with the initial value set to =date()

the value sitting there for a new record is 05/01/2011

even if the clientSideDateFormat is set to dd/MM/yyyy where it does properly affect all fields with a committed date.

I can make my own UDF to manage this, but I'm wondering if the grid's controls should be doing it or I'm missing something.

[kyleim]

Re: Initial value for date w/ clientSideDateFormat

Steve,

Not sure I understand your post completely, but I am having an issue that may be similar. I am attempting to populate initial value of a date field with the value stored in a session variable. If I hard code a string into the initial value field, it will populate correctly, but when I set it equal to a session variable it will not populate. This is only an issue for date fields and not for any other types.

Any thoughts?

[subroto]

Re: Initial value for date w/ clientSideDateFormat

IME, the client side date format doesn't change anything... It all depends on the format on your grid properties->Date Format

Should this be a bug ?

[Steve Workings]

Re: Initial value for date w/ clientSideDateFormat

I'm well through figuring this out now, so I'm happy to discuss. Basically:

A date or calendar selector will do the job just fine in matching the session.__protected__clientSideDateFormat.

But, if you try to supply a date -- such as through the insert of a session variable -- to a control where your variable format is different than you want in the control, you won't get what you want. In other words, you can't expect the control to re-format your date for you when you're inserting an "incorrectly" formatted value.

The solution, of course, is to format the date value the way you need it before trying to insert it. One handy function is the dtoc() function and it's formatting options, e.g.

dtoc(date(),"2/")

[kyleim]

Re: Initial value for date w/ clientSideDateFormat

Cant get it to work. I have an AffFileDate field whose initial value is set to "=session.affdate" and whose display format is "time("MM/dd/yyyy",<value>)"

I also have a for on the same page as the grid it calls the page and uses page variables to populate the session variable in the following manner.

if eval_valid("cmd") 'If for submit button was pressed
	session.xfilpre = xfilpre
	session.affdate = dtoc(ctod(affdate),"1/") 'convert to date then to string to ensure correct format
else
	session.affdate = dtoc(date(),"1/") 'hard coded just to see if I can get it to work
end if

still will not populate the field correctly.

[pcaspa]

Re: Initial value for date w/ clientSideDateFormat

Hi All,

If anyone stumbles across this old thread looking for a solution this video from Selwyn might help

http://screencast.com/t/EOU4y3tFhXU

Cheers
Peter