Convert date (yyyymmdd)

Hi Everyone,
I have the below scenario I need help please:

1-Type Into in application after got date from excel: TransactionItem(“Invoice Date”).ToString
2-I need to insert date in application in this format(20231116)(yyyymmdd)
how can I convert it and insert in type into

@Dhiaa-ABM

datetime.ParseExact(TransactionItem(“Invoice Date”).ToString,"dd/MM/yyyy",system.Globalization.CultureInfo.InvariantCulture).ToString("yyyyMMdd")

mention the format which is present in the TransactionItem(“Invoice Date”).ToString like dd/MM/yyyy

Hi

you can just type CDate(TransactionItem(“Invoice Date”).ToString).ToString(“yyyyMMdd”)

image
image

Thanks Guys I solved it

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