Date input via inputbox

[anand3dinesh]

Hi

i have to feed date to my code trough Inputbox, one thing i noticed is it works fine when i type MM/DD/YYYY format. but i want it change as dd/mm/yyyy
i am trying to filter my data by date available in my sheet but when my code referce to that cell it does not filter any data unless i manually input it in mm/dd/yyyy format

any help please

Thanks

 

[anand3dinesh]

help me

 

[anand3dinesh]

Hello please help me

 

[LazyBug]

Try this:

    Dim sDate$
    
        sDate = InputBox("Input date", "Format dd/mm/yy")
        If IsDate(sDate) Then sDate = Format(CDate(sDate), "dd/mm/yy")