How to Validate date in the format yyyy.mm.dd using vba code

raghuramk · December 13, 2019, 9:43am

Hi,
I need to validate yyyy.mm.dd for a cell in excel using vba code

Palaniyappan · December 13, 2019, 9:52am

Hi
The expression be like this
Inside the FOR EACH ROW loop
Use a IF condition like this

DateTime.TryParseExact(datestring,”yyyy.MM.dd”, System.Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.None, Nothing)

Which will return a Boolean output
Cheers @raghuramk

tdhaene · December 13, 2019, 10:26am

use MM for months
mm are minutes

Palaniyappan · December 13, 2019, 10:33am

Thank you for that… @tdhaene
i typed from my mobile…thats why…
Cheers

AkshaySandhu · December 13, 2019, 11:42am

VBA does not have DateTime.TryParseExact method

AkshaySandhu · December 13, 2019, 11:43am

you can use DateValue function to check if your given date is in specific format or not
like in your case you can use

dVal = DateValue(Replace(ActiveCell.Value, “.”, “-”))
if it throws type mismatch error then cell value is not in correct format

more info

Palaniyappan · December 13, 2019, 11:59am

So This one is from uipath activiy

AkshaySandhu · December 13, 2019, 12:02pm

Isnt that from Vb.Net…?
and OP requested for VBA

Palaniyappan · December 13, 2019, 12:06pm

yes buddy, i suggested with uipath studio
@AkshaySandhu