SQL Help - Conversion of Float

[Saviola]

Howdi,

My brain is misfiring today and I cannot get this to work.

I need to convert a float (ie 20111010010101) into a a Date format I can use in SSRS (for date pickers etc) ie 01/01/2011 or 01-01-2011.

field name in SSRS if you want an to use it = Fields!IS_RECEIVED_DATETIME.Value

For the life of me I cannot get it to work. Would like some fresh eyes if possible.

Cheers
Saviola

 

[Saviola]

Tried both ways but get invalid syntax all the time. I am doing it in the data and not layout, pasted the wrong variable above

table= ISSUES
field= IS_RECEIVED_DATETIME

I must be doing basic wrong as everything else has worked fine just the damn date conversion