I am trying to load only the date from a field which contains date with time stamp. I tried the below code but it is not working as expected. Could you please help me out on this? I have attached the sample application with the qvd file where I am loading from.
LOAD Date(Login,'DD/MM/YYYY') as Login
You can leave the date and floor functions, and that's the correct way to get the results you want.
Floor() rounds the number found in Login down. That's needed because you have some timestamps with decimals, meaning not just a date, but a date with hours and minutes -a timestamp- (DD/MM/YYYY hh:mm). When QlikView interprets a numeric value with decimals as a date, you can make it represent only the DD/MM/YYYY but the subjacent value still has the hour:minute information. That's where the floor() function makes sense.
Hope that helps.
I used the same thing in the application but it is still giving the date with the timestamp. Please let me know what could be the reason behind that. Your solution did worked previously in different application. Here what could be the reason for that?
For your information when I use Date(Floor(FieldName)) in the script it is not working but whereas when I used the same in the front end it works. May I know how can I do that in the backend please.
Previous solution which you gave was working fine only. I did the mistake by giving the alias name which is as same as the field name.
Date(Floor(FieldName)) AS FieldName
When I did the change as below it worked 🙂
Date(Floor(FieldName)) AS FieldName1