Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi kumar,
1) please check is date and time settings are correct in remote desktop.
2) Please let me know the datatype of field.
it is time stamp and find the attachment.
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()))
Hi,
After loading that date field in QlikView what output you are getting??
Regards,
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
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