Get Dates in YYYYMMDD Format

Getting Started
1

Hi All,

How can I get the Dates from today and yesterday in YYYYMMDD Format?

2

Quick & Dirty: theDateObject.SQLDate.ReplaceAll("-", “”)

3

In the new framework using Xojo.Core.Date, the toText() method (by default) returns dates in the following format:

YYYY-MM-DD HH:MM:SS

http://developer.xojo.com/xojo-core-date$ToText

4

dim date as new date date.day = date.day + 1 'date.day = date.day -1 dim formated_date as string = str(date.year)+str(date.month)+str(date.day) msgbox(formated_date)

5

Thank you :wink:

6

[quote=327989:@nicolscanessa] dim date as new date
date.day = date.day + 1 'date.day = date.day -1
dim formated_date as string = str(date.year)+str(date.month)+str(date.day)
msgbox(formated_date)[/quote]

Thank you for the response.
I tried it, but what I get is YYYYMDD instead of YYYYMMDD

7

[quote=327994:@Ricardo Grebien]Thank you for the response.
I tried it, but what I get is YYYYMDD instead of YYYYMMDD[/quote]
Use:

dim date as new date date.day = date.day + 1 'date.day = date.day -1 dim formated_date as string = str(date.year, "0000")+str(date.month,"00")+str(date.day,"00") msgbox(formated_date)
instead.

8

dim theDate as new date dim formated_date_today as string = theDateObject.SQLDate.ReplaceAll("-", "") theDate.totalseconds= theDate.totalseconds - 86400 // Current Date - 1 Day dim formated_date_yesterday as string = theDateObject.SQLDate.ReplaceAll("-", "")

SQL Date Format is always YYYY-MM-DD. So you WILL endup with 20170427 for today for example.

9

BTW

str(date.month) // This will remove the leading 0 before the month is converted to a String

Edit: I think Date.Month has no leading 0 :wink:

10

You know about removing the hyphens from
YYYY-MM-DD HH:MM:SS

I assume you know how to use left() to get the first n characters?

11

[quote=328000:@Simon Berridge]dim date as new date
date.day = date.day + 1 'date.day = date.day -1
dim formated_date as string = str(date.year, “0000”)+str(date.month,“00”)+str(date.day,“00”)
msgbox(formated_date)[/quote]

Thank you, it really helped me :slight_smile:

12

Date.Day gives the day of the year. I never tested what happens if you do the Date.Day - 1 on the 1st day of the Year. :wink:
Because of this i always use Date.TotalSeconds (i know there can be such issues too but it’s far less relevant for my projects) :slight_smile:

13

What do you mean Sasha ?

[quote]Day As Integer (read-only)
The day of the month as a number.[/quote]

AFAIK there is no such thing as dayoftheyear. Although you could calculate it from date.Totalseconds.

14

[quote=328153:@Michel Bujardet]What do you mean Sasha ?

AFAIK there is no such thing as dayoftheyear. Although you could calculate it from date.Totalseconds.[/quote]
Sorry, you are right. :slight_smile:
But there is indeed a DayOfYear.
Will the Year also go -1 if you do a Day -1 on the 1st of January?

PS: I am not a my Dev. Desk currently and can’t perform tests by myself. thank you. :slight_smile:

15

@Richardo: If you use the new Framework, you may like to take a look at DateInterval :slight_smile:

16

[quote=328156:@Sascha S]But there is indeed a DayOfYear .
Will the Year also go -1 if you do a Day -1 on the 1st of January?[/quote]

Indeed, both Date has that.

If it works like anything else in Xojo date, you should see DayOfYear go to 365 and Year decrease by one.