How to create a field and convert "Invoice Date" 2022-06-21 to 202206?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone,
I would like to create a field called "Fiscal Period" and using data from an existing field called "INVOICE_DATE_PK" .The data from "INVOICE_DATE_PK" field is showing as 2022.06.21 and I would like the data from the newly created field Fiscal Period showing as 202206.
Thank you in advance for the help. 🙂
Solved! Go to Solution.
- Labels:
- Datasets
- Date Time
- Developer Tools
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello there,
It did not work. Please see below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oh sorry, I didn't realise you were pulling this from a database. When using the In-DB tools, you have to stick to the correct SQL Syntax. I'm not massively experienced but shouldn't there be a SELECT beforehand? And you may perhaps need to convert the incoming field to a string type (to use the replace/left functions) if it's originally being processed as a Date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the help!
