Solved

Date and Time

  • 4 June 2024
  • 1 reply
  • 32 views

Badge +2

BOB back again, I’ve recently tried to state a if statement with Date = Date. I have excel pulling a date out of its spreadsheet listed as something like 6/1/2024, When I use this if statement I have it see if that date matches the current system date. When formatting the date I use MM/dd/yyyy, it throws this error for me: “The target date/date time format has been entered incorrectly. Please enter a valid date value/format value.”

icon

Best answer by DATTA.KOTHAMASU 5 June 2024, 01:52

View original

1 reply

Userlevel 2
Badge +8

Hi, Please try using the date format as M/d/yyyy.

MM/dd/yyyy

    •    MM: Month with two digits (01 for January, 11 for November)
    •    dd: Day with two digits (05 for 5th, 15 for 15th)
    •    yyyy: Year with four digits (2024)

Example: June 1, 2024 is 06/01/2024.

M/d/yyyy

    •    M: Month with one or two digits (1 for January, 11 for November)
    •    d: Day with one or two digits (5 for 5th, 15 for 15th)
    •    yyyy: Year with four digits (2024)

Example: June 1, 2024 is 6/1/2024.

 

Mark this response as solution if it helps you.

Reply