How to trim time from date

Hi Team,

I want to trim time in date format. For example from ("10/19/2020 17:37:09 ") I want only date.
Can you please provide me the statement to trim after space.

Variable type is date not string

Thank you.

I want this in date format not string

Hi,

I want output in date format not in string format. Could you please help me.

Can you please try to convert to date as below
CDate(inputDate.Tostring(“MM/dd/yyyy”))

Please let me know if it works

Hi Venugopal,

This will work but variable type i will get is string but I want in dae type

Thank you, It worked

@sushma_jaladi

Check Link for your reference for more usecases like this

Hope this helps you

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.