AnsweredAssumed Answered

How do I convert a string to a date

Question asked by davidjohnson5000 on Dec 10, 2016
Latest reply on Dec 12, 2016 by davidjohnson5000

I have a string variable that has the month,day, and year (eg.01/01/2016) and I am trying to Convert the string variable into a date using the Convert Value, but I keep getting the year 1900, eg. 01/04/1900..

 

Why is this occuring.....

 

Note my sequence is

1-Using Build String

   fn-FormatDate({DueDate},MM)/01/fn-FormatDate({DueDate},yyyy) which is stored in a variable called    strFirstDayOfTheMonth

2-Using ConvertValue

   Input is strFirstDayOfTheMonth

   Store Result in dtFirstDayOfTheMonth (date variable)

 

What am I doing wrong

   

Outcomes