You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Fix File layout Date Format Issue

1 reply [Last post]
Lepa's picture
User offline. Last seen 2 years 25 weeks ago. Offline
Joined: 06/23/2008
Posts: 591

Didn't think this is worth it to be a blog post by itself but thought I can still share it with the rest of the community as a forum topic.

This is related to date format when writing data using file layouts. Sometimes, even though your file layout indicates your desired date format, it will still show up weird on your file. Fixing this is pretty simple, all what you have to do is wrapping your date in the select statement as such:

Select %DateOut(end_date)
  From table
 where <where_clause>

Cheers!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Nitin's picture
User offline. Last seen 5 years 48 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: Fix File layout Date Format Issue

This is what PeopleBooks always says:
Use %DateOut in Select and %DateIn in Update/Insert and WHERE Clause

Regards
Nitin