Skip to main content
Solved

Date and Time

  • June 4, 2024
  • 1 reply
  • 337 views
B
Forum|alt.badge.img+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.”

Best answer by DATTA.KOTHAMASU

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.

1 reply

DATTA.KOTHAMASU
Navigator | Tier 3
Forum|alt.badge.img+11
  • DATTA.KOTHAMASU
  • Navigator | Tier 3
  • Answer
  • June 4, 2024

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.

Datta Kothamasu
jon.stueveapeople
B
Terms & ConditionsCookie settingsAccessibility statement