Formatting datefield which contains timestamp

[#1]

Hi All

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.

Login1:
LOAD Date(Login,'DD/MM/YYYY') as Login
FROM
C:\Login1.qvd(qvd);

Thanks

Attitude

[Miguel_Angel_Baeyens]

Hi,

That sounds quite strange. If "FieldName" doesn't exist in your data model more than once, meaning is the only field in your model with that name, you can rename it as you like, and is very usual to rename a field with its own name after doing the required transformation.

Indeed, the following is working for me using your file as posted above, and it keeps only one date, getting ride of the decimal (time) part.

Table2:
LOAD Date(Floor(Login)) AS Login
FROM Login1.qvd (qvd);

EDIT: It's possible that you are loading later that Login field in some other part of your script without formatting and that messes up the data. Check your file attached.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica