Format Issue

[dunnalahk123]

Hi ,

Can some one help me here regarding my month format issue.

Based on the timestamp i am calculating my month fields as per below expression.

year([PSA Project Created Timestamp])& num(month([PSA Project Created Timestamp]),'00')

but for one the snapshot metric i am calculating my month timestamp as per below'

Text(Date(Monthstart(today(),-1),'YYYYMM'))   (Month is 201809)

But when i try below  expression I am not getting months  in order.

Text(Date(Monthstart(today(),-1),'YYYYMM')) 

Sort Order Expression:

=MAX( {$<Region=, Subregion=, Subregion1=, Subregion2=, Country=,Quardent=,Month=,FY_Month=,FY_QM=,FY_Quarter=,FYear=,Metric=>} FY_Month)

[sunny_talwar · Accepted solution]

Why don't you use this

Date(MonthStart([PSA Project Created Timestamp]), 'YYYYMM')

and this

Date(MonthStart(Today(), -1), 'YYYYMM')

[YoussefBelloum]

Hi,

what is the format of your field [PSA Project Created Timestamp] ?

[juraj_misina]

I agree with stalwar1‌: pick one format (ideally Date) and use it in both cases. Otherwise you'll have "discrepancies" like this.

(btw: the sort order you obtain works "as designed" - string values first, followed by numeric values)

[dunnalahk123]

Hi Sunny,

Thank You . you are always awesome.

sorry for my late reply.

Best Regards,

HK