Need to separate day from date

[sruthesanju (Sweety)]

Need to seperate day from date

For example: 11/01/2022

I need to get the output as 1 not as 01

[Anil_G (Anil Gorthi)]

Hi @sruthesanju

Date.parseexact(“11/01/2022”,”MM/dd/yyyy”,system.globalization.culturalinfo.invariantculture).Tostring(“d”)

Plese use this

Or cdate(date).day alao would give it

Cheers

[ppr (Peter Preuss)]

@sruthesanju

11/01/2022

[supermanPunch (Arpan)]

Hi @sruthesanju ,

If the format is the same always, we could try with String Split operation as shown below if the input is a String.

Cint(Split("11/01/2022","/")(1))

[Gokul001 (Gokul Balaji)]

Hi @sruthesanju

Try with this expression

DateTime.ParseExact(StringInput.ToString,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("d")