How to change datetime type to date type

Hi,

I am using chronoform V3.1_RC5.5.

Basically, the data is datetime value so it has a datetime format like '1990-11-11 00:00:00' but, it shows on the chronoform like '1990-11-11-05:00'.

How can I change this type to date value?

Also, if I want to make it correct datetime value, how can I do that?


Thanks.

Hi lmh1213 ,

Dates and times can be messy. Where are you getting this data from? Is it in a database table? If so you can do a conversion in the SELECT statement used to read the data.

And I'm not sure where '1990-11-11-05:00' is or comes from - it looks like it might be an odd format, or a date with a time-zone adjustment added?

ChronoForms does very little with dates so I don't think that it is making these changes??

Bob

Thanks for the reply.

I'm gettting the data from an web service so I can't change the data type with SELECT SQL.

If the data is wrong from the web service, can I change this data format using the java script?

Can you advise me to do this?

Hi lmh1213,

I'd use PHP in the Form HTML box to clean it up.

Bob