problem with timestamp

[Anonymous]

Hi,

I am trying to convert time stamp into date, but i am not able to convert it.

I tried it =

date([Time Full Date],'DD/MM/YYYY') and the expression is ok,but in list box it is displaying nothing. Not only in listbox in all reports the same problem.

Pls help me on this.

Regards,

kumar

[Ralf-Narfeldt]

And if you do a Num([Time Full Date])?

[#3]

try like this:

=Date(Floor(Timestamp#(FieldName, 'YYYY-DD-MM hh:mm:ss')),'YYYY-MM-DD')

[#4]

Hi Kumar,

try like this....

Floor(TimeStamp) As date

or

Date(floor(MyTimestamp)) as MynewDate

or

Date(Floor(Timestamp#(FieldName, 'YYYY-DD-MM hh:mm:ss')),'YYYY-MM-DD') as Date

[Anonymous]

No, it is not working.

[Anonymous]

No, it is not working.

[#7]

can you please add the file with Data then we can help you better.

[Anonymous]

hi

Load a more column in your script

like

Date(floor(Num(FieldName))) as Date

then use it in list box. Hope this will help

Thanks

BKC

[#9]

Hey Kumar,

ping us current time stamp format and  expected date format.

[Ralf-Narfeldt]

This should work:

date(timestamp#([Time Full Date],'YYYY/MM/DD h:mm:ss'),'DD/MM/YYYY')

[PrashantSangle]

Hi,

2 ways to acheive it

1)subfield([Time Full Date],' ',1)

2) date(timestamp#([Time Full Date],'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY')

or

timestamp(timestamp#([Time Full Date],'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY')

or

date(date#([Time Full Date],'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY')

Regards