Convert Date to number crashing Qlik senseServer

[anwarbham]

Hi I am experiencing strange behaiviour

in Qlik view I have a simple etl where I am trying to convert a date time to number 

here is the field in question

Num#(Date(ConvertToLocalTime(Email_Sent_Date_vod__c,'GMT-05:00'),'DD/MM/YYYY')) as JustDateNum,

Qlik view creates the QVD but when I go and try and read it in Qlik sense , it crashes the engine.

and in QMC I can see an engine error

I know its this field because when I remove it the load works fine.

the date comes in this format 

2020-07-01 00:10:40.000

which in number is 44013

I need it to be 30/06/2020 and then in number format 

strange thing is the following fields don't cause  the error

ConvertToLocalTime(Email_Sent_Date_vod__c,'GMT-05:00')as Email_Sent_Date_vod__c ,

Num(subfield(replace(Email_Sent_Date_vod__c,'.',','),',',1))as %Calendar_Key, 

Any Help ?

[rubenmarin]

Hi, have you tried to use Num() instead of Num#()?

Num#() is used to specify the input format of a number, Num() to convert a value to number.

[anwarbham · Accepted solution]

fixed it by using the following 

subfield(Num(subfield(replace(ConvertToLocalTime(Email_Sent_Date_vod__c,'GMT-05:00'),'.',','),',',1)),'.',1) as %Calendar_Key, 

now it does not crash