TimeStamp problem

[Anonymous]

Hello,

I have a strange issue with date column.

I am able to convert date column into MM/DD/YYYY in my local machine, but I was not able do in remote desktop  and it is showing null values.

I used num(date) in script.

Iam able to convert my own format using Left(date,10), but not able to convert DD/MM/YYYY format.

Is there settings to apply for remote desktop version

Please guide me how to achive this thing

Regards,

Kumar

[Anonymous]

Hi Avinash,

As u suggested I tried, but no use. I don't know why it is not displaying data. pls find the screen shot for date column

[#3]

Hi kumar,

1) please check is date and time settings are correct in remote desktop.

2) Please let me know the datatype of field.

[Anonymous]

it is time stamp and find the attachment.

[#5]

Hi Kumar,

First test the below function in the text object in your remote desktop, Is this displaying present date or not. Please let me know on this

=date(floor(now()))

[PrashantSangle]

Hi,

After loading that date field in QlikView what output you are getting??

Regards,

[#7]

Hi Kumar,

After checking for the above script Please try with below functions:

date(floor(MyTimeStamp),'DD-MM-YYYY') as MyDate

or

date(timestamp#([Timestamp],'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY') as NewDate

[Anonymous]

For date(now()), it is giving MM/DD/YYYY format.

After loading into it is displaying data YYYY-MM-DD hh:mm:ss and even i tried with below but no use. It is giving blank

date(floor(MyTimeStamp),'DD-MM-YYYY') as MyDate

or

date(timestamp#([Timestamp],'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY') as NewDate

Regards,

Kumar