Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Date Format

Hi All,

In the Script I am trying to convert Date filed like below but  after reloading the field is banl doesnot show any values in it 

 

Date(weekstart(TempDate,'DD/MM/YYY'),'DDMMMYY') as TestWeekStart,

 

The TempDate format is like :  01/23/2020 

 

How do i convert this into the weekstart format in 1Jan20

 

Thanks in Advance 

1 Solution

Accepted Solutions
sagarjagga
Creator
Creator

If your temp date is in MM/DD/YYYY Format you can use

Date(WeekStart(Date#(Tempdate,'MM/DD/YYYY')),'DDMMMYY')

 

 

View solution in original post

2 Replies
sagarjagga
Creator
Creator

If your temp date is in MM/DD/YYYY Format you can use

Date(WeekStart(Date#(Tempdate,'MM/DD/YYYY')),'DDMMMYY')

 

 

View solution in original post

Vegar
Partner
Partner

The last format string 'DDMMMYY' will not return  1Jan20 but 01Jan20. To get a single digit day you should use 'DMMMYY'.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes