if Date1 > Date2 question

[PHaRTnONu]

So to start, im feeling right dumb i am 99% sure I've done this in the past with out issue

I need to make a logic decision on a action if One date is larger then the previous date

EG: is date 1 in the future or past.

And i can not remember how it was done.
I did look in the forums with out much luck
(maybe convert to unix epoch time coding?)



A easy solution would be much appreciated
(current format is MMMM dd, YYYY

 

[volody00]

 

[PHaRTnONu]

Посмотреть вложение 99186

Посмотреть вложение 99187

Посмотреть вложение 99188

Yeah still not working

This was actually the first way i tried it too

 

[PHaRTnONu]

Actually I had

{-TimeNow.Date MMMM dd, yyyy-} < {-Variable.ReleaseDate1-}

Which still gives the slightly different error but it looks perfect in the logic/return
(will always return false, unless the month is the same then it will give correct information)

 

[backoff]

convert the time to unixtime (this is seconds) and it will be much easier to work with them

time now in unixtime

int unixTime = (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds;
return unixTime;

converting human time to unixtime

var datestr = project.Variables["time_in_human"].Value; /// переменная с вашей датой
DateTime date = Convert.ToDateTime(datestr);
int unix = (Int32)(date.Subtract(new DateTime(1970, 1, 1))).TotalSeconds;
return unix;

 

[PHaRTnONu]

im still stuck with this MMMM dd, YYYY format

 

[backoff]

im still stuck with this MMMM dd, YYYY format

this is a bad format to work with, use unixtime and everything will work fine right away.

 

[PHaRTnONu]

this is a bad format to work with, use unixtime and everything will work fine right away.

...........
Im pulling/scraping the date.
its not like i can just call and tell them to change it

HENCE me asking for a solution

 

[PHaRTnONu]

convert the time to unixtime (this is seconds) and it will be much easier to work with them

time now in unixtime

int unixTime = (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds;
return unixTime;

converting human time to unixtime

var datestr = project.Variables["time_in_human"].Value; /// переменная с вашей датой
DateTime date = Convert.ToDateTime(datestr);
int unix = (Int32)(date.Subtract(new DateTime(1970, 1, 1))).TotalSeconds;
return unix;

I was able to get it eventually.
So thank you

var datestr = DateTime.ParseExact(project.Variables["ReleaseDate1"].Value, "MMMM dd, yyyy", System.Globalization.CultureInfo.InvariantCulture);
DateTime date = Convert.ToDateTime(datestr);
int unix = (Int32)(date.Subtract(new DateTime(1970, 1, 1))).TotalSeconds;
return unix;

This will help me alot (wanted to make sure i left the code incase any one needs to convert Dates the C# conversion DateTime.ParseExact is defiantly helpful

 

[PHaRTnONu]

(couldnt edit, but if you have issue's you can make if case's so if you dont have dd you do d, or if you dont have the days at all remove the dd altogether, same for the month (if you only had the year) it would be yyyy in the "" )

i put like 5 if case scenarios in there but you get the jist (plus i dont have the editor open so dont ahve the code off hand but wanted to leave the information incase any one need's this in the future