Date issue

[#1]

Hi all.

I have two tables and one of them have a date field called "AnswerCreated" and the format for that field is "2014-02-04 19:42:22.130" and when I look at it in QV "41407,71546412".

I would like to use that field as a key to a Calendar but what is the best way to format that field?

See attached qvw.

[Nicole-Smith]

Settings > Document Properties > Number:

[MK_QSL]

Either use below in UI side

=Date(Date#(AnswerCreated,'YYYY-MM-DD hh:mm:ss'))

Or below in script side

Date(Date#(AnswerCreated,'YYYY-MM-DD hh:mm:ss')) as AnswerCreated

[#4]

Yes, I would like to do it in the script but that doesn't work. The field AnswerCreated is empty, doesn't you need to take care about the last three numbers?

[sunilkumarqv]

open the script

Please find the attached give feed back hope thio helps you

[manojkulkarni]

use

Date(AnswerCreated,'YYYY-MM-DD') AS Date...

[ashwanin]

use

Date(AnswerCreated,'DD-MMM-YYYY') As AnswerCreated

in the script.

[er_mohit]

Try this in text object

=Date(Date# ('2014-02-04 19:42:22.130','YYYY-MM-DD hh:mm:ss.fff'),'YYYY-MM-DD hh:mm:ss' )

[sunilkumarqv]

try this into your textobject not required that of script Mohit.

=Timestamp#(Now(),'DD/MM/YYY hh:mm:ss')

[PrashantSangle]

Hi,

try this

timestamp(timestamp#(AnswerCreated,'YYYY-MM-DD hh:mm:ss')) as AnswerCreated