Date Problem in BLS

[Former Member]

Hi,

I am reteieving the date from mySQL server and other data. I am doing claculation and displaying the SPC chart.

My problem is as i have used the date data type in bls, it automatically getting converted with time stamp.

Can anybody expain how to get rid of this.

Thx

Supriya.

[Former Member]

Problem was solved

[Former Member]

Supriya

Just use this function

<b>stringleft(Repeater_0.Output{/Row/pdate},10)</b>

Regards

Som

[Former Member]

Hi Supriya

Use <b>dateformat( datetime, fromformat, toformat )</b> in your link Editor

replace datetime with your date column which u want to convert

fromformat with the existing format

toformat with the format which u need

Regards

Muzammil

[Former Member]

Hi Muzammil,

I did in the folloiwng way but not getting correct result but it is getting converted to default date : 1970-01-01 T:05:29:59.

I used the following code --

dateformat((Repeater_0.Output{/Row/pdate}),"YYYY-MM-DD THH:MM:SS","YYYY-MM-DD")

Thx

Supriya

[jamie_cawley]

pdate is probably an xml date and your to and from formats are incorrect. The formats are case sensitive.

mm = minutes

MM = month

You will probably want to use

datefromxmlformat( Local.tt, "yyyy-MM-dd" )

Regards,

Jamie