Date Extraction

[David_K]

Hi Fellow Qlik Sense users,

Does anyone know how I can just take the day number from the date:

eg: 25/01/2004  =   25  (represents the 25th day of month)

I have tried 'LEFT', 'MID' 

date(date("sales date",'dd/mm/yyyy'),'DD') AS SALES_DATE  

but I cannot get the actual output I am looking for.

Many thanks in advance,

David

[peterwh · Accepted solution]

Hello,

did you try the "day"-function already? It's available in cloud and on prem.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun... 

Kind regards

Peter

[David_K]

Hi Peter,

Of all the things I tried, that is one I didn't, and thank you for helping - provides the perfect output.

Thank you.