2 Replies Latest reply: May 15, 2014 10:14 AM by JLain _ RSS

    How to convert a date using a calculated field

    JLain _

      How do you convert a date field in a db where the field format is changed to short date in excel upon loading into monarch as a db but Monarch refuses to recognize anything in this column as a date...rather "Type" is grayed out as "character" and format is general. Eventhough the format is date in the db prior to importing now that the column of dates is in Monarch I am struggling trying to get Monarch to be able to convert anything in this column to a date field. Tks