Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
convert created_time to floor date format?
Date(Date#(Left(created_time, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD') as Date1
How many times did you ask the same question . Try not to duplicate the same thread
Sorry
Please cclose this thread by marking correct or helpful answers.
Hi,
Check with this,
Date(Date#(SubField(created_time,'T',1),'YYYY-MM-DD'),'MM/DD/YYYY') as Date
HTH,
Hirish