Date Format

[smilingjohn]

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 · Accepted solution]

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

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

[Vegar]

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