
Anonymous
Not applicable
2015-05-08
03:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
convert to yyyymm
hi,
how can ı convert DATE to YYYYMMDD format?
like to function in SQL >> to_char(date,'yyyymm')
thanks.
9,402 Views
1 Solution
Accepted Solutions

Not applicable
2015-05-08
03:11 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this: Text(Date(YourDateField,'YYYYMMDD'))
8,147 Views
5 Replies

Anonymous
Not applicable
2015-05-08
03:10 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
date(date#(date,'YYYYMMDD'),'YYYYMM')
8,147 Views


Specialist II
2015-05-08
03:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Hopes this helps
Date(Date#(DateField,'MM/DD/YY'),'YYYYMMDD ')
8,147 Views

Not applicable
2015-05-08
03:11 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this: Text(Date(YourDateField,'YYYYMMDD'))
8,148 Views

Not applicable
2015-05-08
03:14 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The expression convert your date field in a string
8,147 Views

Anonymous
Not applicable
2015-05-08
03:17 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks this is more general expression.
