Skip to main content
Nintex Community Menu Bar

Date from text to Date format

  • Aug 8, 2017 8:14 PM UTC
  • 2 replies
  • 22 views
  • Translate All

Forum|alt.badge.img+3

Hello,

So I have imported data from an excel sheet into a list, with two columns possessing dates.  However, these dates are in the format of October 1st.

206364_pastedImage_1.png

There are hundreds of lines in the excel sheet that have now been inserted as items to the list, so it would be disadvantageous to manually alter this data, but is there a fast way to convert this when I am trying to do a comparison to another date?  Currently I would need this in the workflow, however I could work it in the form as well.  But the comparison is in my workflow.  

206365_pastedImage_2.png

This is how I currently have it setting up the comparison, however this is before I realized how the Season End was getting input from the other list.  

Thank you,

Duncan Leathrum

2 replies

Forum|alt.badge.img+14
  • Scholar
  • Aug 9, 2017 10:06 PM UTC

first of all I'd suggest to reimport excel data once again with full date format.

how can you know out of this whether 'October 1' is lower or greater then 'February 28'?

if you managed to import them in ISO format like YYYYMMDDTHHMISS then you wouldn't need any conversion and could compare them directly as strings.

Translate

Forum|alt.badge.img+3
  • Author
  • Aug 14, 2017 12:40 PM UTC

Good suggestion.  Thank you for it!

Translate