The end result it to be able to filter the converted field using the built in “From, To”” calendar function provided for data fields of date type. Not sure what's not allowing the from and to functionality since the field has been converted to a date type.
Answer
Is it possible to remove the Time stamp when converting a string to a Date
Best answer by Samvel Petrosov
It looks like you are trying to convert the FinPeriod ID to the Start Date of that Fin Period.
Now the approach you take may be fine in case when the Fin Periods are matching the Calendar month, but otherwise this may cause an issue.
I would recommend instead of doing this, simply join the MasterFinPeriod table on FinPeriodID and then use the StartDate.
That should solve your problem and also account for the actual start date.
+8Hi
Try specifying a Schema on the result column. You can use any date field from the data sources in your GI.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+8It looks like you are trying to convert the FinPeriod ID to the Start Date of that Fin Period.
Now the approach you take may be fine in case when the Fin Periods are matching the Calendar month, but otherwise this may cause an issue.
I would recommend instead of doing this, simply join the MasterFinPeriod table on FinPeriodID and then use the StartDate.
That should solve your problem and also account for the actual start date.
Samvel Petrosov | www.iigservices.com | https://www.linkedin.com/in/samvel-petrosov-096880107/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.