Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankit1988
Contributor III
Contributor III

Proper Date format

Ankit1988_0-1682759538397.png

Hi.

I have dataset in Excel Format which have only two date field one is [Month of coding] and another is [Accessible Month] and value is in the both field is look like the attach above snapshots.

so let me know with the help of [Accessible Month ] how to generate standard Date format. like in DD:MM:YYYY or DD/MM/YYY Format.

 

Thanks  

 

Labels (1)
11 Replies
Ankit1988
Contributor III
Contributor III
Author

its working

 

Rams-
Creator
Creator

In inline table instead of Sep'21, try Sept'21

load * inline [

MonthOfCoding
Oct'21
Nov'21
Dec'21
Apr'21
Jun'21
Jul'21
Sept'21

];