Date

[smilingjohn]

Hi All, 

I have date field from oracle in the below format of the screenshot , I am converting this into QVD and in the 2nd layer when i try to conevrt this format to 'DD/MM/YYYY' this is not working . I tried all the possible methods but i am not able to convert this date format Could someone please help me on this ? 

Thanks in Advance

[smilingjohn · Accepted solution]

This got worked with below function 

date(floor(Date),'DD/MM/YYYY') as Date