Date variable looking like a float value

[#1]

Hi,

In my report I have two variable that are set from a calendar. Sometime when I select dates, they ends up like this :

42456.1234 and some other time like this 43245. Why does those value is float ? The decimal part represent what ? Hours ? This is causing issues with my report.

On the other hand, I have others calendar that store only Integer in the variable. Someone can explain to me, how this happen ?

Thank you.

Daniel

[sunny_talwar]

Not sure how you are creating them, but yes, the decimal parts represents time information. Would you be able to share how are you creating them to see what is going on?

[marcus_sommer · Accepted solution]

Yes it meant it's then not a date else a timestamp with hours, minutes and so on - you could solve it by loading these date-field with:

date(floor(YourDateField), 'YourFormatPattern') as YourDateField

- Marcus

[#4]

Of course:

This when I load from the QVD:

This the calendar configuration:

This is how the variables looks like:

Is this enough for you ?

Thank you.

[#5]

Thank you.

[sunny_talwar]

Can you try loading OrderDate like this:

Date(Floor(OrderDate)) as OrderDate