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