Convert Datetime to Date

[vrdabberu (Varunraj Dabberu)]

@ManjunathReddy

Try this and it will give you the required output

Regards

[ManjunathReddy (P Manjunatha)]

you can see my below variables and their values

I have to apply A date “2023-07-14” in database query through parameter in Date format.

[Anil_G (Anil Gorthi)]

@ManjunathReddy

So in your db the date format is as you specified with hyphen?ideally just a conversion should be enough

Please check this

DateTime data insert to sql server

Hi @Shyam_Pragash You can use this conversion where you can include time as well Datetime.ParseExact(“yourdatestring”,”MM/dd/yyy hh:mm”,System.Globalization.CulturalInfo.InvariantCulture) MM/dd/yyyy hh:mm - this is the input format so chamge it according to the input you get from excel If you want any specific date format then use .Tostring(“format you need”) like “dd-MM-yy hh:mm” Cheers

Cheers

[Vikas_M]

Hey, @ManjunathReddy

Date.Today.ToString(“yyyy/MM/dd”)

u can use this :), it works!