Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I extract the date in the format of yyyy-mm-dd from the given highlighted data
you Need to Format it to your requirements.
date(date#(left(text(Disposal_Date), 8),'YYYYMMDD'),'YYYY-MM-DD')
i did left(Disposal_Date, 😎 till now
what Format is Disposal_Date ? Number?
then try
left(text(Disposal_Date), 😎
i currently did left(Blige_Disposal_Date,8) and for that my data is coming like 20161215..I want to have it in the form 2016-12-15 format..
you Need to Format it to your requirements.
date(date#(left(text(Disposal_Date), 8),'YYYYMMDD'),'YYYY-MM-DD')
Date(Date#(Sludge_Date, 'YYYYMMDD'),'YYYY-MM-DD')
Its working..anyways thanks