Date conversion shows no date

[Jayz1489]

Hi everyone,

I am having this weird issue and unable to understand why.

I am having a csv like:

Date	UserEmail	RecoverableSize	MFADaysAgo
9/16/2021	abc@gmail.com	51.9598	1

I checked in the csv, date is considered as date and when I am loading it on qliksense, with simple statment  "Date" as "Report Creation Date" , it is able to process in the charts like Fig1.

Also see the change in format of csv and qliksense..from mm/dd/yyyy to mm-dd-yyyy

However, when I am using max function on recoverable size using latest date. It is not showing nothing.

so I tried changing the date format....Whenever I am loading the date with any changes ..like Date(Date#("Date",'MM/DD/YYYY'),'MM/DD/YYYY') AS "Report Creation Date", script successfully runs but nothing is processed.

Can someone please help and tell me what's happening. 

[PrashantSangle]

Can you share sample data??

or share you script

[PrashantSangle]

To check the format of the date open that csv in notepad. then you will see actual format of date

also FYI, 

mm -> minutes

MM-> Month

if you are using small letter (mm) then replace it with capital letter (MM)

Regards,

Prashant Sangle