Convert string to date

[hjm35055]

Hi,

I have a standard calendar date field in the format of MM/DD/YYYY.

I created a fiscal month field and a fiscal year field off of the calendar date above.

Then I merged the fiscal year and fiscal month together to create a field that looks like 'YYYY-MM'.  This field is a string and I need to convert it to a date.

Thank you,

[Mauritz_SA]

Hi there

Try Date#([Field Name],'YYYY-MM')

Good luck.

Mauritz