topic Date Format in QlikView

Date Format

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

sagarjagga — Mon, 24 Feb 2020 17:54:57 GMT

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

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

Vegar — Mon, 24 Feb 2020 18:12:44 GMT

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