Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Champs
I need to format date in my expression to be like YYYY-MM-DD
i have below in my expression and in my table.
Below is where i need to make my changes
Below is the Merit date i need to Change to YYYY-MM-DD?
Thank you in advance.
Just change ur date
from :
MeritDate
to :
Date(MertiDate,'YYYY-MM-DD')
or date(timestamp#(MertiDate,'YYYY-MM-DD hh:mm:ss.ffff'),'YYYY-MM-DD')
Just change ur date
from :
MeritDate
to :
Date(MertiDate,'YYYY-MM-DD')
or date(timestamp#(MertiDate,'YYYY-MM-DD hh:mm:ss.ffff'),'YYYY-MM-DD')
Hi ,
you can use following expression .
Date(Date#(subfield([Merit Date],' ',1),'YYYY-MM-DD'),'YYYY/MM/DD')
Change the format of date as per your data.
Regards,
Prashant
you can do it using the Floor function as below:
=date(Floor( date#([Merit Date], 'YYYY-MM-DD hh:mm:ss.ffff' ) ), 'YYYY-MM-DD' )
I hope it helps.
Hi Omar
Thank you very much.
Hi Prashant
Thank you very much for your help it works as well !
Hi Andrea
Thank you very much for your help it works as well !