locked
convert text to datetime RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a textbox value '10/17/2017' and '10/01/2017' would like to convert to a datetime value and do a calculation to get the difference of two days.

    Are there any function to convert the text value in the text box to datetime value?

    Your information and help is great appreciated,

    Regards,

    Sourises,

    Tuesday, October 17, 2017 1:49 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    If you're using VBA, have you tried the CDate() function? For example:

    DateDiff("d",CDate("10/1/2017"),CDate("10/17/2017"))

    Hope it helps...

    • Marked as answer by sourises Tuesday, October 17, 2017 3:23 PM
    Tuesday, October 17, 2017 3:10 PM